Automatically transfer selected data to another sheet on print

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

Guest

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.
 
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
 
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
 
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
Click to expand...
 
Back
Top