Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default data on multiple sheets HELP!!

Not sure what I did but I've got a workbook with 12 sheets in it. I'm
entering data on sheet 12 and it's populating all 12 sheets with that
data. please help!!!!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 284
Default data on multiple sheets HELP!!

dhusband

Is the word [Group] in the top of your workbook, right after the workbook
name?

If so right click the tab and select "Ungroup".

Mike Rogers

" wrote:

Not sure what I did but I've got a workbook with 12 sheets in it. I'm
entering data on sheet 12 and it's populating all 12 sheets with that
data. please help!!!!

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default data on multiple sheets HELP!!

On Dec 18, 9:01 pm, Mike Rogers <Mike060349@NoxSpamxAOLDOTcom wrote:
dhusband

Is the word [Group] in the top of your workbook, right after the workbook
name?

If so right click the tab and select "Ungroup".

Mike Rogers



" wrote:
Not sure what I did but I've got a workbook with 12 sheets in it. I'm
entering data on sheet 12 and it's populating all 12 sheets with that
data. please help!!!!- Hide quoted text -


- Show quoted text -


I don't see anything that says 'group'. Other suggestoins?
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default data on multiple sheets HELP!!

On Dec 18, 9:18 pm, wrote:
On Dec 18, 9:01 pm, Mike Rogers <Mike060349@NoxSpamxAOLDOTcom wrote:





dhusband


Is the word [Group] in the top of your workbook, right after the workbook
name?


If so right click the tab and select "Ungroup".


Mike Rogers


" wrote:
Not sure what I did but I've got a workbook with 12 sheets in it. I'm
entering data on sheet 12 and it's populating all 12 sheets with that
data. please help!!!!- Hide quoted text -


- Show quoted text -


I don't see anything that says 'group'. Other suggestoins?- Hide quoted text -

- Show quoted text -


Poking around looking for a 'group' function I found that selecting
all sheets and then ungrouping them worked. Is there a keystroke I may
have hit to group sheets inadvertantly? I don't want to do that again.
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 284
Default data on multiple sheets HELP!!

dhusband

Usually sheets get grouped by either selecting them one at a time while
holding ctrl key or selecting a range of them by hold the shift key. Usually
the word [Group] (in square brackets) appears after the workbook name. It is
helpful to group sheets while doing some of the formating and/or layout of
several sheets. But it is critical to ungroup them when you do not want the
same data to go across all sheets.

I am glad you solved your problem.

Mike Rogers

" wrote:

On Dec 18, 9:18 pm, wrote:
On Dec 18, 9:01 pm, Mike Rogers <Mike060349@NoxSpamxAOLDOTcom wrote:





dhusband


Is the word [Group] in the top of your workbook, right after the workbook
name?


If so right click the tab and select "Ungroup".


Mike Rogers


" wrote:
Not sure what I did but I've got a workbook with 12 sheets in it. I'm
entering data on sheet 12 and it's populating all 12 sheets with that
data. please help!!!!- Hide quoted text -


- Show quoted text -


I don't see anything that says 'group'. Other suggestoins?- Hide quoted text -

- Show quoted text -


Poking around looking for a 'group' function I found that selecting
all sheets and then ungrouping them worked. Is there a keystroke I may
have hit to group sheets inadvertantly? I don't want to do that again.

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
Data Population for multiple sheets Shaun Excel Discussion (Misc queries) 1 February 22nd 07 06:33 PM
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA Amaxwell Excel Worksheet Functions 4 August 17th 06 06:23 AM
Help with Looking up data in multiple sheets compconnj Excel Worksheet Functions 0 March 21st 06 03:50 PM
Data from multiple sheets the-jackal Excel Worksheet Functions 1 February 16th 06 08:07 AM
combining data from multiple sheets Allen Way via OfficeKB.com Excel Worksheet Functions 1 April 5th 05 06:02 PM


All times are GMT +1. The time now is 08:02 PM.

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

About Us

"It's about Microsoft Excel"