Automatically transfer selected data to another sheet on print

F

FFW

Hi,

I have an invoice template set up and rather than saving an electronic copy
of each invoice I would like to transfer selected data from each completed
invoice automatically to a sales database sheet once an invoice is printed. I
have no idea how to go about this.

All I wish this database to hold is the invoice number, date, customer
reference and total amount invoiced. All of said information are idntifiable
as individual cells in my invoice template being B7, F7, D7, F43 respectively.

What I would ideally like is for the values contained in these cells to be
transferred as soon as the invoice is printed. I also need the database to
expand automatically i.e. to copy the information in the next available row
and not overwrite previous entries.

Please help!! Thanks in advance.
 
F

FFW

Thanks for the quick response but yes I'm afraid I do need more help.

I need to copy the values of cells B7, F7, D7 & F43 from sheet 1 to columns
A, B, C & D in sheet 2. I'm not sure which code on that page will allow me to
do this.

Thanks
 
R

Ron de Bruin

I always do this

In your sheet in a row below your data
In row 40 for example, i use formulas like this

In A40 =B7
In B40 =F7
...........
..........
You can hide that row

This way you can use the Range or row example to copy to yout database sheet
 
F

FFW

Thanks, this worked perfectly!

Ron de Bruin said:
I always do this

In your sheet in a row below your data
In row 40 for example, i use formulas like this

In A40 =B7
In B40 =F7
...........
..........
You can hide that row

This way you can use the Range or row example to copy to yout database sheet
 

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

Top