Retrieving Data from Multiple WorkBooks

M

mastermind

What I need is a macro that will retrieve data from multiple workbooks
and then take this data and populate a summary sheet. To be more
specific, I need the macro to find every excel workbook in the current
directory (The directory where the summary sheet is located) with a
name like "681(1) Est. *.xls", and then copy the title of the sheet and
a particular range in that file:

Range("I9:I28,I31:I35,I38:I56,I68:I81,I84:I87,I90:I102,I105:I117")

I then need the code to go to Sheet1 of the summary sheet, insert the
previously copied sheet name into Range("G7"), and populate the rows
immediately bellow the title with the other information copied from the
sheet. If there is more than one file the program should know to move
over one column in the summary sheet and perform the same actions
above. If anyone can give me some help that would be great.

Summary sheet Ex:


Item No. Description Unit Est (1) Est (2)
....... ............. ....... .......... ...........
....... ............. ....... Retrieved Retrieved
....... ............. ....... Data Data
....... ............. ....... .......... ...........
....... ............. ....... .......... ...........
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Too Long 8
Copy from multiple workbooks, rename, and overwrite if exists 4
VBA data from Closed workbook Question 2
Macro to copy from workbooks listed as http links 8
save data , images and hyperlink between two workbooks 2
Import Data from Multiple Sources 8
Collate data from multiple workbooks into one worksheet 0
Error retrieving data from closed workbook 5

Top