Automatically transfer selected data to another sheet on print
 

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.

Automatically transfer selected data to another sheet on print
 

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"FFW" wrote in message ...
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.

Automatically transfer selected data to another sheet on print
 

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" wrote:

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"FFW" wrote in message ...
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.

Automatically transfer selected data to another sheet on print
 

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"FFW" wrote in message ...
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" wrote:

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"FFW" wrote in message ...
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.

Automatically transfer selected data to another sheet on print
 

Thanks, this worked perfectly!

"Ron de Bruin" wrote:

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"FFW" wrote in message ...
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" wrote:

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"FFW" wrote in message ...
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.