Creating an Invoice ?

[tennielle]

I am having trouble with adding an invoice date, number ?

I am also having trouble allowing my user to save details of th
current item to the invoice . How do i create one invoice item to b
displayed at one time ?

I also need your help to be able to clear the sheet for the nex
invoice but still allowing all the Vlookup's and formulas to b
remaining.

I also need your assistance to save the summary of each invoice to
summary worksheet.

I know there are alot of questions i hope you can help me !!!!!

People like me shouldn't study IT.

Thanks
:

 

[Debra Dalgleish]

There's a sample file here that might help you get started:

http://www.contextures.com/excelfiles.html

Under 'Data Validation', look for 'Invoice for Selected Number'