I copied straight from your web site, can you send me an example because I
still cant get it to work

Thanks for all your help

"Ron de Bruin" wrote:

Read good

Important: The macro examples use one function or two functions that
you can find in the last section of this page.

Copy the LastRow function also in your module


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"David Shoemaker" wrote in message
...
It is giving me a compile error saying (sub or function not defined)

Sub Copy_To_Another_Workbook()

Lr = LastRow(DestSh)

"Ron de Bruin" wrote:

See the last example on this page
http://www.rondebruin.nl/copy1.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"David Shoemaker" wrote in message
...
I have a workbook that i enter data into, and i want to take certain data in
that workbook and transfer it to another workbook with a pivot table so i can
use it like a data base so i can search or orders

.


.