Thanks for taking a look at my question.
I have a large worksheet that I have recently developed for a workbook that my company has many, many copies of already existing. The new worksheet does not need to be incorporated into all of them, just a handful. it is sufficient to copy the worksheet from the workbook it was most recently used in to another one when that needs to be done.
However, often times when I try to copy the sheet over from one workbook to another I get a message saying:
"Excel cannot insert the sheets into the destination workbook, because it contains fewer rows and columns than the source workbook. To move or copy the data to the destination workbook, you can select the data, and then use Copy and Paste commands to insert it into the sheets of another workbook."
Attached are two blanked out workbooks, a source and a destination. Can someone please tell me what I can do besides copy and pasting? Copy and pasting the actual ranges inevitably leads to lots of clean up and re-creating buttons and such.
The sheet in question that I want to copy is called "PVA Information"
SafetyFish Destination.xlsm Source.xlsm