Hi Apeople members!!! Could you guys please help me to know that: How to copy specific columns from one excel sheet to another excel sheet?
Hi Apeople members!!! Could you guys please help me to know that: How to copy specific columns from one excel sheet to another excel sheet?
![Collaborator Bronze Badge](https://uploads-us-west-2.insided.com/automationanywhere-en/attachment/fee7f4b5-b93b-4ad9-b9d0-d7e4b4be4c9a_thumb.png)
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
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.