Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / November 2006

Tip: Looking for answers? Try searching our database.

Stop excel from copying data from one sheet to another

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Imajica - 03 Nov 2006 17:24 GMT
I have a workbook (actually 75 workbooks) and it has ten worksheets. In each
sheet I have a subtotal at the end of each row (34 in all) and at the bottom
of each column (25 in all)  I have copied this formula onto each sheet.  The
problem I am having is that in the blank cells (of any worksheet), I enter a
number and it is being transposed onto the other nine worksheets.  I have no
formulas in any of the cells or the other worksheets telling it to transfer
the information.  What I need to know is, how do i stop it from copying
information from one sheet to the other without having to redo my workbooks?
Bob Umlas, Excel MVP - 03 Nov 2006 19:53 GMT
Sounds like you're in group mode. Right-click a sheet tab and select Ungroup
Sheets, and this behavior should stop.

> I have a workbook (actually 75 workbooks) and it has ten worksheets. In each
> sheet I have a subtotal at the end of each row (34 in all) and at the bottom
[quoted text clipped - 4 lines]
> the information.  What I need to know is, how do i stop it from copying
> information from one sheet to the other without having to redo my workbooks?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.