Hello,
I am trying to create a macro that will extract data from multiple workbooks (closed if possible) and summarize into a new sheet.
In each workbook, I have a sheet named "Indirect Build Up Reference" and from this sheet I need the data from cells E271:K274.
I've been using the code from this site which I found on another thread here: http://www.rondebruin.nl/copy3.htm
But it's a little complicated and I keep getting a "Compile Error."
I've attached the code I have so far in a Word document in case anyone can work with it.
Any help or suggestions are greatly appreciated!
Crissy
Bookmarks