Thread: Automatic transfer of cell details

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

Muckshifter Wrote:
> 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.

I would switch to Access. I personally feel that too many users try to
force Excel to be a database when it isn't. It is easy to put the data
in but not easy to get it out in a format you want.
Access will allow you to enter the data and then select what data you
want included in you output.


--
jahoobob