Matthew has attended:
Project Management - Framework & Processes course
Excel Intermediate course
Excel Advanced course
Excel VBA Introduction course
Is there a way to make excel tally for me?
The problem is as follows. I am given a long list of handwritten items with a quantity next to them. For context this relates to the number of lab supplies taken form a store room.
I then have to go down the list and input into excel how many of each item have been taken. The problem is that the items repeat. So somebody might have taken medium gloves and then something else. Then the next person might come in and take medium gloves. They don't add it up for me so i get given a long list of items.
E.g.
Gloves M - 27
Pipettes - 30
Scalpel - 50
Gloves M - 10
What i am doing at the moment is just quickly do the addition in my head as i add the info to excel. So if there was 27 taken before and now another 10 i change it to 37. i would like to be able to just input the 10 and then excel would automatically add it to the previous number to get to 37.
I hope that is clear enough.
looking forward to your feedback.
Matthew
RE: Is there a way to make excel tally for me?
Hi Matthew
This is a common question. There isn't a quick way to tally numbers and yet it is often wanted.
I'm sending you a file which contains a simple macro. You type the added numbers in one column and when you press a button it adds them to a remaining column and then deletes them.
How it works
The macro uses one of the Paste Special operations called Add.
You can do it manually as follow:
Copy cells C2:C30
Right click in B2
Choose Paste Special, Add, OK
Then highlight C2:C30 again and press Delete key.
But clicking the button is much faster and more fun!
Let me know if you can open the file. You need to select the Enable Content button after opening.
Regards
Doug
Best STL
Attached files...
RE: Is there a way to make excel tally for me?
Hi Doug,
Thanks for getting back to me.
I have not received a file. Does it come via email or do I need to find it on the website?
Many thanks
Matthew
RE: Is there a way to make excel tally for me?
Hi Matthew
Sorry about that. Please can you email Doug@stl-training.co.uk and I'll send you the file.
Thanks
Doug
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.