Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging data between 2 files
Morning all,
I have been trying to get excel to automaticaly update cells from another xls file but have been unable to do it, can you help? I have an invoice.xls and an addressbook.xls, instead of copy/paste the customer data cell by cell I would like to type the company name into the correct cell on the invoice and have excel get the additional data (address, tel, vat no# etc etc) from the address book file. this would be a great tool for thousands and cant believe that it does not allready exist. as it seems really simple with regards to some of the great solutions already here, can anyone help? many thanks in advance Carl |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging data between 2 files
Check out VLOOKUP in help.
I would assume you need an exact match, so check out the last argument, "Range LookUp". NickHK "tecnicopc" wrote in message ups.com... Morning all, I have been trying to get excel to automaticaly update cells from another xls file but have been unable to do it, can you help? I have an invoice.xls and an addressbook.xls, instead of copy/paste the customer data cell by cell I would like to type the company name into the correct cell on the invoice and have excel get the additional data (address, tel, vat no# etc etc) from the address book file. this would be a great tool for thousands and cant believe that it does not allready exist. as it seems really simple with regards to some of the great solutions already here, can anyone help? many thanks in advance Carl |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging data between 2 files
cheers for the help, I will do that :-)
thanks again |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excell-merging data from 2 files | Excel Discussion (Misc queries) | |||
merging files | New Users to Excel | |||
merging several files into one | Excel Programming | |||
Merging two different files | Excel Discussion (Misc queries) | |||
Merging Files | Excel Programming |