Copying cell value to master report file which is closed?

K

Kevin

Hi,

Could someone please advise how can I achieve following task:

We have few guys in office who use excel worksheet to generate invoice for
our clients. The format of worksheet is standard for all users but I like to
generate the summary of all invoices they make.

In other words, as soon as they generate a new invoice it should be added to
the master file. I need only few cells to be copied to master file like
invoice No, amount, due date etc.

Let me simplify further: How can I copy Cell "A1" & "B5" values to a
independent master file. Every time when new values are added to these cells
it should automatically added to the database.

Any help or advise would be highly appreciable.

Thanks
Kevin
 
B

Barb Reinhardt

You'd need to do this using VBA if you want it automated each time. If
that's what you want to do, come back and let us know.
 
Top