step1- open both the excel by using excel advance package and make sure about that both the excel have different session name.

step 2- Select the column by using “Select cells/rows/columns” action from excel advance package

step3- use “keystrokes” from simulate keystrokes package and pass CTRL+C (in select window choose application and in drop down choose currently active)

step4- use “Go to cell” and pass the first cell address of the column where you want to paste the values(make sure about that session name you pass is of excel sheet where you want to paste column)

step5- use keystrokes CTRL+V