Pulling specific data from multiple workbooks into one

[Aggie2014]

Hi all,

I have been reading many of the posts on this board that have helped me immensely in learning VBA, however the macro that I’m working to create now hasn’t had a discussion that I’ve been able to find.

I have about 15 files with different financial data in a folder; each file has different amount of rows but they all have several Rows with category names and totals. For example “total revenues” and “Total capital outlay” that are located in column C with the totals following in Columns D-I.

what I’m looking for is a macro that will copy those rows with totals from each workbook into a new summary workbook.

complicating matters further, each file contains a unique name in cell A3 that I would like to show in the summary workbook to identify which file the totals came from.

apologies for the rambling but I wanted to describe the conundrum in the most detail possible. Thanks all!

 

[Aggie2014]

Don't ask my why or how but the compile error went away even with the asterisks present, however I get a different error when I run the code that the macro couldn't find the path C:\Users\XXXX\AppData\Roaming\Microsoft\Excel\XLSTART\ and is asking if it was possible that it was moved, renamed , or deleted. I have the summary workbook and the data files all saved in the same folder on my desktop so I'm not sure why it's looking in another directory...

 

[Fluff]

Is the code in the "Master" workbook, or in your Personal.xlsb file?

 

[Aggie2014]

It was in the Personal.xlsb. Once I moved it to the summary, it worked great. Thanks all for the help!

 

[jolivanes]

Thanks Fluff.
I should go shopping more often and come back to solved problems!
Happy New Year to you and yours for both.

 

[Aggie2014]

Thanks and Happy New Year!