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.

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" <[email protected]> wrote in message news:[email protected]...
> 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


"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" <[email protected]> wrote in message news:[email protected]...
> > 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.
>
>
>

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" <[email protected]> wrote in message news:[email protected]...
> 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" <[email protected]> wrote in message news:[email protected]...
>> > 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, 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" <[email protected]> wrote in message news:[email protected]...
> > 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" <[email protected]> wrote in message news:[email protected]...
> >> > 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.
> >>
> >>
> >>
>
>
>