I am trying to create a automatic invoice using excel. On the forth tab is the invoice- when I select the invoice number (N3) I want it to automatically fill the client name(D11) enter the date from range (f21) and enter the date to range(h21) and enter the unit price (i21)
The data sources is on tab 3 (MCL Totals)
I have been playing with VLOOKUP but cant quite get the syntax right. Been trying for about 3 hours now and going mad so any help would be so great. was using http://www.excel-easy.com/examples/automated-invoice.html
as a guide if this resource helps anyone.