View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rahul
 
Posts: n/a
Default 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