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.
Sorry.. Not sure why this error comes. I first create a new workbook (Ctrl+N); then I just rightclick on the pane and select move or copy. In the pop-up window, I check "Copy" and in the dropdown I select the new workbook (Book1).
Leave a Reply
Your are not logged in . Please login to post replies