Copying cell value to master report file which is closed?

[Guest]

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

 

[Guest]

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.

 

[Guest]

Yes please it needs to be automated each time...

 

[Gord Dibben]

Kevin

See Ron de Bruin's site for varying methods of copying.

http://www.rondebruin.nl/tips.htm

Browse through the Copy/Paste/Merge Examples.


Gord Dibben MS Excel MVP