Find all instances and copy to new sheet??

**hclark579** · 04-10-2013, 04:17 PM

I have a workbook with 26 sheeets. On each of the sheets is a Name and a Cost column amongst other data. I need on a new sheet a master list of every name that appears anywhere in the workbook along with the total of the Cost columns associated with that name. Is this possible? I am attaching the file. Thank you for any help!

**AB33** · 04-10-2013, 04:36 PM

You mean you want to add the cost for each name

**hclark579** · 04-10-2013, 04:38 PM

Yes, I need a grand total for each name.

**AB33** · 04-10-2013, 04:39 PM

Check the attached

**hclark579** · 04-10-2013, 04:42 PM

You are a lifesaver! Thank you so much

**AB33** · 04-10-2013, 04:46 PM

hclark,
I have just noticed that you have a sheet called "Grand Totals". I did not see it. Do you want the total goes there instead of the summary sheet?

**hclark579** · 04-10-2013, 04:50 PM

No worries, I just used the Summary sheet. That is perfect!

**AB33** · 04-10-2013, 04:52 PM

hclark,
You are welcome!
Could you please now close (Mark) this thread as solved? Go in to the top right-hand side of this page, choose "Thread Tools" from the menu, then select "solved" from the drop down menu.