View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve[_79_] Steve[_79_] is offline
external usenet poster
 
Posts: 8
Default Importing names from one excel file to another

Hi All,



I am looking for some help with the following:



I have an excel spreadsheet that I am using as a

master database. This database needs to be updated quarterly

with the names of various individuals from four different regions.



In order to make the data entry more convenient I would like

to provide a template workbook to various folks who will be responsible

for completing the data for their regions.



Once the template workbook is returned, I would like to click on a

button in the master database file which will allow me to specify the

location of the template file and import all the names from the various

template files into the master database starting at the next empty

row in the master database.



Any ideas on how to accomplish the above?



All suggestions welcome.



Thanks,



Steve