J
John
Hi,
I have setup an invoice system in Excel which does all the vat
calculations and shows net costs,total costs, ect.I now want to keep a
single row record of each invoice I create in a seperate datasheet.The
pertinent details would be recorded in adjacent cells on individual rows for
each new invoice created. Is there some way of setting up a button which
when activated will print a copy of the current invoice I have completed and
create a record of the details in an adjacent worksheet.
I also need to set up an invoice numbering system which will be based on
the current date eg. 070705 01,070705 02,ect. and will automatically
generate a new number each time I start a new invoice.This could be linked
to the aformentioned button. Tia, John
I have setup an invoice system in Excel which does all the vat
calculations and shows net costs,total costs, ect.I now want to keep a
single row record of each invoice I create in a seperate datasheet.The
pertinent details would be recorded in adjacent cells on individual rows for
each new invoice created. Is there some way of setting up a button which
when activated will print a copy of the current invoice I have completed and
create a record of the details in an adjacent worksheet.
I also need to set up an invoice numbering system which will be based on
the current date eg. 070705 01,070705 02,ect. and will automatically
generate a new number each time I start a new invoice.This could be linked
to the aformentioned button. Tia, John