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

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.

"Kevin" wrote:

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

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


"Barb Reinhardt" wrote:

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.

"Kevin" wrote:

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

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

On Sun, 8 Apr 2007 09:54:02 -0700, Kevin
wrote:

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


"Barb Reinhardt" wrote:

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.

"Kevin" wrote:

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