Import data from multiple Excel files to 1 Excel file.

[agengler11]

I know that after a few searches Ive seen this done before but not quite how I am looking to do it..... That being said, I have multiple files that are layed out the same and I want to pull the data out of each file in that directory and import it so the data is cleaner.


For example: The files have the date in cell D4, I want that data to go into cell B2. The part number is in cell D5, I want that to go into cell C2

The data that I want to pull is all over the page and I just want to put all of it on 1 line per file that it looks at.

Thanks in advance!!

[bonny24tycoon]

In order for us to prepare the code, we would need some example workbooks... Can you attach your example workbooks and outline how your output should appear??

[agengler11]

This is the spreadsheet with the data. There are about 1200 of these.

[agengler11]

Please Login or Register  to view this content.

[agengler11]

This will work if I can keep changing the keep selecting source ranges. I dont know how to add more code to this to add more. Help?

[arlu1201]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.