Hi all, I am only new to ExcelBanter, I have made up an invoice in Excel 2003, I invoices numbered from 1 through to say 100, I have made up a customer database on a seperate worksheet in the same workbook, I would like to gather the customers names, address, Town, Phone Nos etc to the data base, however I am having a problem finding the right formula to put this info from the invoices as they are used. Every cell is 58 cells apart for each invoice as it is used, can someone hepl me with a formula that will pick out this info for me as the invoices are used and placed in the database starting with customer No1 and then so on down the list, thanks in advance for any help.
Much appreciated.
Bazza

are you trying to update the database from the invoice particulars or
populate data into the invoice from the database. Try out excel function
vlookup to collect data with matching criteria.

"Bazza" wrote:


Hi all, I am only new to ExcelBanter, I have made up an invoice in Excel
2003, I invoices numbered from 1 through to say 100, I have made up a
customer database on a seperate worksheet in the same workbook, I would
like to gather the customers names, address, Town, Phone Nos etc to the
data base, however I am having a problem finding the right formula to
put this info from the invoices as they are used. Every cell is 58
cells apart for each invoice as it is used, can someone hepl me with a
formula that will pick out this info for me as the invoices are used
and placed in the database starting with customer No1 and then so on
down the list, thanks in advance for any help.
Much appreciated.
Bazza




--
Bazza

Hi Vijay, thanks for replying, I tried the vlookup but it doesnt work, all I want to do is make a list of customers surname, first name, address, town etc from each invoice as it is used, maybe the problem is that I did not make these items into a table, they are just single cells on an invoiceand then the next invoice is 58 cells down in the same row, every invoice is the same as this. Thanks for your help.

Bazza