Need Help With a Excel 2003 Formula

B

Bazza

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
 
V

Vijay_India

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.
 
B

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
 
Top