How to import names into Excel
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
|