Copy and Paste excel

[sando]

I remember seeing this some time ago but can not find it now.
I have two workbooks and I want to select the columns from workbook 1 and paste them to workbook 2. and save the sheet as a something besides sheet1

Can anyone help

Thanks in advance

 

[maxmangion]

simply click on the letter of the column which you want to copy so that it gets highlighted, then right click and click on Copy, then go to the sheet where you want to paste the column and simply paste it.