Automatically transfer selected data to another sheet on print

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

 

[Ron de Bruin]

Hi FFW

See this page for code examples
http://www.rondebruin.nl/copy1.htm

You can use the beforeprintevent to run the code
http://www.cpearson.com/excel/events.htm

If you need more help post back

 

[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

 

[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

 

[FFW]

Thanks, this worked perfectly!

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