I have a workbook with 18 worksheets. I am using this workbook for employee
reviews; I am recording performance in each workbook and I have a "summary"
page that I have formulated to average the performance scores from selected
cells within selected worksheets. What I would like to do next is to "auto"
fill in data from other worksheets. For example I have a cell with the text
"Employee Name" in it and in the following cell I have typed that employee's
name. I have the same "format" on each worksheet and I would like to set up
each worksheet to fill in text with the same text on the main page.

I dont fully understand what you want.You can copy a whole sheet to another
position in the book or make it a new sheet.
You can type in a cell on your main sheet(say sheet1) to reflect data from
any cell on sheet2 =Sheet2!A1 or type the =,then navigate to the sheet and
cell you want and select with the mouse which will give the same type of
formula.You can then build rows or columns for each seperate sheet.If you
change something on sheet3,it will imediately change on sheet1\Is that what
you need?
--
paul

remove nospam for email addy!



"RLG" wrote:

I have a workbook with 18 worksheets. I am using this workbook for employee
reviews; I am recording performance in each workbook and I have a "summary"
page that I have formulated to average the performance scores from selected
cells within selected worksheets. What I would like to do next is to "auto"
fill in data from other worksheets. For example I have a cell with the text
"Employee Name" in it and in the following cell I have typed that employee's
name. I have the same "format" on each worksheet and I would like to set up
each worksheet to fill in text with the same text on the main page.

Juat another interp angle to it ..

Perhaps what you're seeking to do could be achieved via INDIRECT

A simple example to illustrate the possibilities ..

Assume we have 3 source sheets: Sheet1, Sheet2, Sheet3
and we want to extract data from certain cells (say, from cells A1 and A3)
in each sheet into a new "summary" sheet (Sheet4)

In Sheet4,
list the 3 source sheetnames across in B1:D1, viz.:
Sheet1, Sheet2, Sheet3

Then list the cell refs of interest down in A2:A3,
eg: A1, A3

Then, we could put in B2: =INDIRECT("'" & B$1 & "'!" & $A2)
and copy B2 across & down to D3 ..

B2:D2 will return the same as the link formulas:
=Sheet1!A1, =Sheet2!A1, etc

B3:D3 will return the same as the link formulas:
=Sheet1!A3, =Sheet2!A3, etc

INDIRECT will resolve the concatenation of the sheetname and cell ref text
strings to return the results from the particular sheet and cell listed in
B1:D1, and in A2:A3. So we could design the layout and define / change the
sheetnames and cell ref text strings in the header row/col to suit the
purpose.

And for a neater look, we could also suppress the display of "extraneous"
zeros in Sheet4 via clicking: Tools Options View tab Uncheck "Zero
values" OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"RLG" wrote:
I have a workbook with 18 worksheets. I am using this workbook for employee
reviews; I am recording performance in each workbook and I have a "summary"
page that I have formulated to average the performance scores from selected
cells within selected worksheets. What I would like to do next is to "auto"
fill in data from other worksheets. For example I have a cell with the text
"Employee Name" in it and in the following cell I have typed that employee's
name. I have the same "format" on each worksheet and I would like to set up
each worksheet to fill in text with the same text on the main page.