I am trying to move a worksheet from one workbook to another. I have never
had a problem with this in the past, but now that I have Office 2007 I seem
to be having trouble.
The error message I receive is: 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 the Copy and Paste commands to insert it
into the sheets of another workbook.
Of course, that is not much of an option as it looses all my formatting,
grouping, etc.
Could you please offer some assistance?
Thanks