Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

is there way make

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Is there a way to make excel tally for me?

Is there a way to make excel tally for me?

ResolvedVersion 2013

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...

Lab List.xlsm

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.

Fri 27 May 2016: Automatically marked as resolved.

Excel tip:

Transpose text

You can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps:

Select the range.

Click the Copy button on the Standard toolbar to copy it to the Clipboard.

Select a cell outside of the range you copied.

Select Paste Special from the Edit menu.

In the Paste Special dialog box, click Transpose, then OK.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.