I am trying to create a Macro that will copy a worksheet from a workbook and then paste it into another worksheet in another workbook while keeping format and layout. Anybody know how to accomplish this?
I am trying to create a Macro that will copy a worksheet from a workbook and then paste it into another worksheet in another workbook while keeping format and layout. Anybody know how to accomplish this?
Open both workbooks in the same instance of Excel and use the macro recorder. Then you can modify the macro to make it more general.
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks