Show us your code then

--

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




"cluckers" wrote in message ...
Thanks for the post. However, I have gotten the macro to work but sometimes
it does not always exoprt the data to the destination workbook. Do you know
why this sometimes does not work?

"Ron de Bruin" wrote:

Hi cluckers

Maybe this will help

See the last example on this page : What if the Database sheet is in another workbook
http://www.rondebruin.nl/copy1.htm

--

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




"cluckers" wrote in message ...
Is there a way to export a range of data of my current worksheet to the next
blank row on a closed workbook? I have a template excel file used to place
orders and I want to copy the order information (ex B3:F3) to the next
available row in a workbook that has all of the orders.

Thanks