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
--
EMoe
------------------------------------------------------------------------
EMoe's Profile:
http://www.excelforum.com/member.php...o&userid=23183
View this thread:
http://www.excelforum.com/showthread...hreadid=470659