If your list isn't too long, use a formula in the new sheet that simply says
A1 = "Sheet Original" A1 Simple: type = then click on original page and
select A1 on the original. Touch Enter.
You now have 1 formula in new sheet. Copy this formula down as far as you
need in column A, adding enough rows for future names to be added. Each time
you add a name, it wqill appear in all sheets where you have this formula.

Hope this is what you want. If not, explain further.

Rahul wrote:
I have a problem trying to keep my list of names up-to-date across several
spreadsheets. I had a list of names defined in a master spreadsheet.
Everytime I made a new Excel file I copied a dummy sheet from the master file
to the new file so that all the names became visible in the new file. I hope
you understand what I'm trying to say!

BUt now whenever I add a new name to "master" it (obviously) doesnt show up
in the daughter sheets until I manually copy the dummy sheet to the daughter
sheet again. Is there a way to automate this? i.e. define names in only a
central location and have them show up in all new sheets I make?

Thanks!

-Rahul

--
Please take a look at www.openoursite.com and you will see how I want to
use.

God Bless for helping

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200604/1