COPY WORKSHEET: not working?

[itr674]

I have a large file and am copying worksheets one at a time out of that book to another workbook. When I do the Move or Copy and select Create a Copy and then try to move it to another book it does not go there.

I can get it to move to a single workbook, but then I can't get it to move to the new workbook that is much smaller than the original workbook???

 

[Andrew Poulsom]

Two options:

1. Select all the sheets you want to copy by clicking the first tab and Shift+clicking the last tab (or you can use Ctrl+click if they are not contiguous). Then choose Move or Copy, Copy, (new book).

2. After copying the first worksheet make sure you choose the book that's just been created, not (new book) again.

 

[itr674]

Andrew - well I finally got it working by making a forth book and then copying sheet from third book into second book then saved and closed all books. Then reopened books 1 and 2 and everything is working agian.

I have this large workbook that jumped from 1.8 mb to 3.1 mb and am trying to determine bad sheet...

 

[itr674]

Just noticed something--if I go to a page and do an F5 then select Special and then select Blanks shouldn't all the blanks cells be highlighted.

When I did this on one sheet it is not highlighing the supposedly empty cells from col H to IV?

I manually selected those columns using Shift-Control_Right Arrow and then did a Edit-Clear-All and then did a re-check using F5 and it still didn't highlight the cells???

 

[Andrew Poulsom]

Edit|Goto|Special|Blanks selects only the blank cells within the used range. Try it on a new worksheet. You will get the message "No cells were found".