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 |
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 |
Merging data between 2 files
cheers for the help, I will do that :-)
thanks again |
All times are GMT +1. The time now is 07:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com