Macro Help

[Norm Hamilton]

I want to copy a Row of Text Data from 1 workbook and locate a blank row
in the 2nd work book to past the data.. Each time data is pasted it
will be on a new row.

I want this to be a Macro.

 

[liddlem]

Hi Norm

I replied to a similar question on this forum which can be found at
http://www.excelforum.com/t175709-s

You may have to tweak the code a little to suit your needs.
Hope it helps

 

[Tushar Mehta]

See the Excel/VBA/'Beyond Excel's recorder' page of my web site,
specifically, example 2
http://www.tushar-
mehta.com/excel/vba/beyond_the_macro_recorder/index.htm

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions