Hello,

I'm looking for a code that will copy data from column B (say B5:B10) on sheet1, workbook name DataInfo. Then open a workbook named DataTable on c drive (c:\DataTable), then paste the values on sheet1, starting at row 4 (say B4:G4 going across). With each click of the button the macro need to paste down to the next row directly under the first set of numbers; click again, next row.

I've seen macros that pastes from column to column. I don't know how to go from one row to the next.

Thanks,
EMoe