Copying cell value to master report file which is closed?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically Linking New Spreadsheets to Master File 1
template creates invoice - how to create summary worksheet? 13
Automatically copy from Master worksheet to others 3
Access Access 2010 multi page invoice report 0
Transfering a changing cell value progressively through a workbook 3
selecting values from a list to equal a given value 3
cell reference to another file 1
link values from same cell of 20 worksheets into column on one she 3

Back
Top