Transfer data to another sheet

kevin

you extended the number of lines for the invoice sheet do you intend to use that many?
if so...on the index did you want to transfer every single line of the description over?
if so is the value per line or per invoice?



minor amendments to the clear invoice was required as you added extra lines
what do you intend to use cell C40 for?

2. Total invoice value to index is ok,

what do you want as the description then?

C40 was just text "Please use reference No"

does this change from invoice to invoice or will remain the same everytime?

also with vat
are all your invoices vat?
are you going to use that check box Vat applicable?
if not will just get rid of it


also on the index tab
did you want total value prior to vat or vat inclusive?

ok see attached

your invoice is slightly different to the one i prepared the other time so the coding is slightly different in places
i added feature that will make it ask you to check first row if you have not completely it in full

this is done by cell N39 which is hidden along with all the course dropdown list

the vat i have left in
the controller of this is C45 (its in WHITE font so you dont see it)
you might want to move the check box into the invoice print area if you want it shown on the invoice

as vat calculates differently
subtotal now has a different formula as well

Formula:

Please Login or Register  to view this content.