Skip to main content
Ground Control | Tier 1
April 8, 2022
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?

  • April 8, 2022
  • 1 reply
  • 244 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

    Cadet | Tier 2
    April 8, 2022

    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