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