Pat

Most likely a separate sheet for the invoice sheet and some VLOOKUP formulas
pointing back to the data sheet to fill in the blanks.

For more on VLOOKUP see Debra Dalgleish's site

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben Excel MVP

On Tue, 19 Jul 2005 15:21:01 -0700, Pat Flynn
wrote:

Am looking for a method to create an invoice from data in excel rows ie
name, address, etc, invoice# and amount. Would appreciate it if someone could
point in right direction.
Thanks
Pat