ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   data on multiple sheets HELP!! (https://www.excelbanter.com/excel-discussion-misc-queries/170180-data-multiple-sheets-help.html)

[email protected]

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!!!!

Mike Rogers[_2_]

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!!!!


[email protected]

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?

[email protected]

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.

Mike Rogers[_2_]

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.



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com