I produce invoices in Excel which are continually being updated
throughout the month.
Data on the invoices includes details of two types of work done and
cost, plus invoice total.
I need the individual figures to transfer across automatically to
separate spreadsheets as I enter them on the invoice(so as to produce a
list of each individual customer cost for each type of work).
I also need the invoice total(which is continually being updated as
more jobs are added) to transfer to a third spreadsheet to produce a
grand total at month end.
Where on earth do I start? My knowledge of Excel is very basic!
I would be most grateful for any advice.
--
Muckshifter
Bookmarks