Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
flaguilar
 
Posts: n/a
Default eliminate data entered to a worksheet that copies to another work.

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.
  #2   Report Post  
JulieD
 
Posts: n/a
Default

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

"flaguilar" wrote in message
...
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.



  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

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

On Mon, 14 Mar 2005 07:45:02 -0800, flaguilar
wrote:

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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
extract data from worksheet sallu Excel Worksheet Functions 2 February 21st 05 07:50 AM
How do I compare similar rows of data in same worksheet JT Excel Worksheet Functions 2 February 20th 05 07:11 PM
Help with data not getting plotted Scott Ehrlich Excel Discussion (Misc queries) 2 January 25th 05 06:17 AM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 04:30 AM
Calculating using data from another worksheet Sid N Excel Worksheet Functions 1 October 28th 04 10:58 PM


All times are GMT +1. The time now is 10:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"