Excel Noobie needs some help with a macro that will copy a specific cell in all Workbooks in a given folder

I was tracking and comparing some values in an excel sheet that does sums a column.  Fairly basic and straighforward, that sheet was then saved to represent a day in a given month.  Now after about 6 months of this, i am told need to sum all the sheets.  It isn't huge number, but over 10 or so different topics, 10-20 or so sheets a month, so cumulatively speaking, it is a lot.  

Essentially I just want a new sheet that will look at all files in a given folder and add the value s found in say C12 in all the WBs.  I was thinking of just making one for each month, and hoping it would then be able to go to look in the folder it resides, and any sub folders it finds and add up this specifc cell, which is the same in all the WB.  

Excel 2010 if it matters.
LVL 9
tsaicoAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Zack BarresseCEOCommented:
Hi there,

I'm trying to understand you. You speak of summing 'sheets', but then talk about different 'workbooks' in a folder (including subfolders). Can you clarify? Do you mean you want to

-Choose a folder

-Sum C12 (whatever you specify) in every sheet of every book of every folder (and subfolders)?
OR
-Sum C12 (whatever you specify) in every sheet of a single book
OR
-Sum C12 (whatever you specify) in a single sheet of every book of every folder (and subfolders)?

Regards,
Zack Barresse
0
tsaicoAuthor Commented:
Sorry, should have been more clear.

-sum c12 in a single sheet of every book of a specific folder and it's subfolders.
0
broro183Commented:
hi tsaico,

Ron DeBruin has created a useful, and free, add-in which can do this for you. The add-in is described on this page:
http://www.rondebruin.nl/win/addins/rdbmerge.htm

Zack, the flexibility of RDB's add-in may save the need for more questions to get clarification (eg the sheet name or number of sheets in the file). ;-)

hth
Rob
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
tsaicoAuthor Commented:
Exactly what I needed.  Thanks so much!
0
broro183Commented:
Thanks tsaico - I'm pleased I could help,

Rob
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.