Same Text on Multiple Worksheets

[Brennan]

I need to enter text into certain fields on a worksheet and I want that text
to repeat automatically on other worksheets in the same workbook.
Cell references on the other worksheets are not the same as the original
worksheet.

 

[Dave Peterson]

You can use formulas that point to any cell on that original worksheet. It may
be a pain to set it up the first time, but once it's done, it's done.

=if(sheet1!a1="","",sheet1!a1)
can go in any sheet in any cell to retrieve the value from A1 on sheet1.

This is nice for titles.

But if you have a key unique value in a column, you may be able to use
=vlookup() or =index(match()) to return a value from a cell in that same row
based on that key column.

You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))

 

[Brennan]

Thanks Dave, works great
--
PB

You can use formulas that point to any cell on that original worksheet. It may
be a pain to set it up the first time, but once it's done, it's done.

=if(sheet1!a1="","",sheet1!a1)
can go in any sheet in any cell to retrieve the value from A1 on sheet1.

This is nice for titles.

But if you have a key unique value in a column, you may be able to use
=vlookup() or =index(match()) to return a value from a cell in that same row
based on that key column.

You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))