Macro to copy from one sheet to another -

[jamesruk]

I have a sheet called "my Master sheet.xlsm" where the macro will be saved.

The master sheet will be open, I will then also open an excel sheet that has been emailed to me (where the file name will change)

I would like to run a macro to copy all data from cells B2:M64 from "Sheet1" of the emailed sheet, into sheet 1 of my master sheet.

Sounds simple, but don't know how to do it without the filename of the emailed file


any help urgently appreciated!!

Thanks

[Pepe Le Mokko]

This nice and safe add-in will do that for you http://www.rondebruin.nl/win/addins/rdbmerge.htm

[mgs73]

I'm sure there is a more elegant way, but this should do the trick. It will only work if you only have your master workbook and email workbook open, and nothing else.

It loops through all the open workbooks (as I said there should only be two for this solution to work) and then returns the one that isn't the one running the macro.

Please Login or Register  to view this content.