COPY WORKSHEET: not working?

itr674

Well-known Member
Joined
Apr 10, 2002
Messages
1,778
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???
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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

Well-known Member
Joined
Apr 10, 2002
Messages
1,778
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

Well-known Member
Joined
Apr 10, 2002
Messages
1,778
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

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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".
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,837
Messages
5,766,721
Members
425,373
Latest member
ndiejennrrd

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top