Macro that copies one row from a workbook to the 1st blank row on another workbook

[Adam1027]

Hi Everyone,

This is my first post.

I need a code to copy a single row (Range A3:AD3) from one workbook (Data.xls) to the first empty row of another workbook (Record.xls).

Lets say I have a work book called Data.xls with the data on sheet1

And I have another work book called Record.xls where this will be pasted to sheetA

These names are just examples, but if anyone can provide me with code for the maco I would greatly appreciate it. I haven't been able to find something this simple online.

This is Excel 2003 fyi.

-Adam

[JBeaucaire]

Please Login or Register  to view this content.