Copy Range All Sheets from Closed Workbook

[jonathann3891]

Whats up everyone?

I'm looking for a macro that will allow me to select a workbook that is closed via dialog box.

I need to copy range("D3:H67") from closed workbook, and paste it to range("D3:H67") of active workbook
I need it to do this for all sheets that have data in that range.

I've tried several things and couldn't yield the results I was looking for.

Thanks,
Jonathan

[Mumps1]

Hi Jonathan. If you have multiple sheet with data in that range and copy each of them to D3:H67 one range of data will overwrite the previous one. Could you please clarify?

[jonathann3891]

Yes it could overwrite which isn't a concern.

[Mumps1]

If it isn't a concern, then your final outcome in the active workbook will be the data from the last sheet in the closed workbook. If this is the case, then it is pointless to as you say in your original post:

do this for all sheets that have data in that range

You would only need to do this for the last sheet, not all sheets. Am I interpreting correctly what you want to do?

[jonathann3891]

It would have to be from the first sheet to the last sheet with data.

It doesnt matter to me if it loops through all sheets.

[Mumps1]

Try:

Please Login or Register  to view this content.

Change the folder path to suit your needs.