master sheet setup

  • Thread starter Thread starter Aladd1n
  • Start date Start date
A

Aladd1n

hello,

i have a workbook w/approx 20 worksheets used for purchase orders. som
info on each of the 20 sheets will be the same (i.e. project name
model number, name of client etc...)

i would like to enter this info on only one sheet (call it the maste
sheet) and have the info copy over to the same cells on each of th
other 19 pages.

i experimented with the paste special command but i had no luck.

thanks in advanc
 
Before Typing anything in a cell Group the sheets you wish to be affected.
Click on FirstSheet hold down the Shift Key and click the Last Sheet.
With FirstSheet active and at say cell B3 - enter This is a test; << Press
Enter_key
Then DON'T_FORGET - Immediately UNGROUP the Sheets by Right-Clicking on
any one and selecting Ungroup sheets. Failing to do so will really
mess-up-things...
HTH
 
Why not use formulas that reference desired info on your master sheet?

For example you can access the project name using something like...

=Master!B2

Where

Master! is the name of the sheet containing the project name
B2 is the cell ont he master sheet containing the project name

You can also create range names for your master information. I could, for
example, select cell B2 on the Master sheet and use the
Insert-->Name-->Define command (or click in the Name Box on the Formula Bar)
and name the cell Project. Once named, I can refer to the project name in
any cell using the following formula...

=Project

Taking this one step further, you can refer to master information as part of
other formulas using the Ampersand symbol:

="The name of the project is "&Master!B2&"."

or if using a range name...

="The name of the project is "&Project&"."

--
_______________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel
http://www.r-cor.com
 
thanks for the replies, the formula approach is what i was looking fo
and im sure the inser:name function will come in handy. thanks agai
 
Back
Top