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

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.