Linking/connecting nine separate worksheets of a workbook

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

Guest

Is there a way, after formatting nine separate sheets in a work book like
sheet 1, sheet 2, sheet 3, etc., that I could connect or link these (I hope I
am using the right words), so that if I change say the header on one sheet,
the same change is automatically made on the other sheets, that the page
numbering is automatic, that the column cells (for different vendor names
that are set up say on the first sheet are repeated on the other sheets),
like in a bid tabulation. The only difference would be the actual technical
data filled-in on each sheet, which obviously would be unique for that sheet.

Thank you very much.
 
What you are looking to do is "Group" the WSs together.

You can click the tab of the first sheet, hold down <Shift>, and then click
on the tab of the last sheet. Or, to group random sheets together, click on
the "main" sheet, hold <Ctrl>, and click on the tabs of the individual
sheets.
The tabs are now all White, with the first, main focus sheet also in bold.
In the Title Bar, following the sheet name, you'll see the word "Group".

Now, anything done to the main focus sheet will be duplicated on *all* the
other grouped sheets.

When you've completed making your revisions and/or additions, don't forget
to Ungroup the sheets, or you'll create some real problems when you continue
to duplicate unwanted entries into the other sheets.
You can right click in a tab, and choose "Ungroup Sheets".
 
Another option is to put the real headers in a sheet (say sheet1). Then use
formulas to point at each of the header cells.

Say A1:G2 on sheet1 contain the headers.

Then group (like RagDyer explained) all the other sheets (don't include Sheet1).

Type this in A1:
=if(sheet1!a1="","",sheet1!a1)
and drag across to G1 and then select a1:g1 and drag down to a2:G2.

Format the cells the way you like (bold/colors).

And ungroup the sheets.

If you need to change the headers, you can just change the headers on Sheet1.

===
An alternate suggestion that I like much better. Put all your data in one
worksheet. Add a column (new column A) that indicates the vendor name.

Then apply Data|filter|Autofilter to the range. If you want to see vendor aaaa,
just filter on column A to show/hide what you want.
 
More awesome!
Thank you.

Ragdyer said:
What you are looking to do is "Group" the WSs together.

You can click the tab of the first sheet, hold down <Shift>, and then click
on the tab of the last sheet. Or, to group random sheets together, click on
the "main" sheet, hold <Ctrl>, and click on the tabs of the individual
sheets.
The tabs are now all White, with the first, main focus sheet also in bold.
In the Title Bar, following the sheet name, you'll see the word "Group".

Now, anything done to the main focus sheet will be duplicated on *all* the
other grouped sheets.

When you've completed making your revisions and/or additions, don't forget
to Ungroup the sheets, or you'll create some real problems when you continue
to duplicate unwanted entries into the other sheets.
You can right click in a tab, and choose "Ungroup Sheets".
Click to expand...
 
Back
Top