MACRO COPY/PASTING
 

How can I program a cmd button that will copy a col(from workbook1) and paste
to 2nd workbook as paste value and transpose (to paste in a row).I would like
for the macro to also move to the 2nd empty row after paste on the 2nd
workbook

Thanks

MACRO COPY/PASTING
 

The easiest way to get the code together is to record a macro that
includes all the steps you require. When you get that finalized you
can assign the macro to a command button.