eliminate data entered to a worksheet that copies to another work.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When posting data to one worksheet, in an Excel file with multiple
worksheets, the data from the posted worksheet will appear in one or more of
the other worksheet. I had this problem when copying a Lotus wksht to Excel
but I have now experienced the same problem when setting up a new Excel file
with multiple wkshts.
 
Hi

sounds to me like your sheets are getting grouped ... before pasting, ensure
only the sheet tab of the sheet you want to paste to is white (better still
right mouse click on it and choose ungroup sheets if it is an option).

Cheers
JulieD
 
Do you have links in the other sheet(s) like =Sheet1!A1 or similar?

Or do you have two or more sheets "grouped"? i.e. do you see [group] in the
titles bar?

If so, right-click on a sheet tab and "Ungroup"


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Vlookup Function with multiple worksheets 6
How do I copying data from a cell on sheet to a diff cell/sheet 1
Excel Move or Copy Stopped Working? 0
How 2 import Excel file w/ multiple worksheets ??? 1
Using Worksheet Name 3
How to use multiple command button to copy user form data to multiple worksheet 0
Copy data from one worksheet to another 5

Back
Top