Question

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?

  • 8 April 2022
  • 1 reply
  • 36 views

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?

1 reply

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