Copy LInes From One Sheet To The Last Line In Another Workbook

**markswan20** · 09-30-2009, 09:29 AM

Hello everyone,

I have searched the forum for posts that explain how to copy lines from certain cells to other certain cells at the end of a different workbook but can't seem to find the answer i need.

Here i am trying to copy between B25 - G25 through to B40 - G40

I need them to go into a seperate workbook underneath the previous entries and not overwrite anything.

A macro of some sort would be the best for me if this is possible.

I have included a copy of the 2 sheets for ref:

I would very much appreciate if someone could point me in the right direction.

Many thanks
Mark

**JBeaucaire** · 09-30-2009, 12:23 PM

Install this macro into your invoice and give it a try:

Please Login or Register  to view this content.

**markswan20** · 10-01-2009, 07:29 AM

Thank you for your reply it's works a dream only one problem sometimes there might not be an entry in the first column and this means it will overwrite the other data but there is always information in column D is this possible.

Many Thanks

**JBeaucaire** · 10-01-2009, 11:00 AM

Please Login or Register  to view this content.

**markswan20** · 10-01-2009, 12:17 PM

Brilliant response.

Works a traet thank you

**JBeaucaire** · 10-01-2009, 02:14 PM

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)