Skip to main content
Question

Copying an entire row from one worksheet to another


interplan
Forum|alt.badge.img+7
Good Afternoon, fellows.I have two separate sheets: Sheet "A" and Sheet "B". I've already managed to get the number of a cell in the spreadsheet "A". Now I need to copy the entire row of this cell from worksheet "A", to worksheet "B". How can I do this? Thank you in advance.

3 replies

Tamil Arasu10
Most Valuable Pathfinder
Forum|alt.badge.img+16
  • Most Valuable Pathfinder
  • 3276 replies
  • March 27, 2023

Hi @interplan ,

You can’t copy the entire row. However you can use the Excel Advanced Package

Open Excel→ Get multiple cells --->Loop Action (read only the A row and directly write into the B ).

 

Please note, you can also try with copy the entire row by passing the simulate keystroke shortcut keys 


Shoeb Shk
Forum|alt.badge.img+6
  • Navigator | Tier 3
  • 38 replies
  • March 27, 2023

Hello @interplan ,

Step 1 : Open Excel A & Excel B (Different session name)

Step 2: Get multiple cells from Excel A , make sure u pass here the same session name which you have used to open the excel sheet and willing to copy the data from.

Step 3: Loop through all the row in the table

Step 4: Use key stroke to copy the entire row to clipboard

Step5: Set the variable to other excel sheet.

 

Thanks

Happy Automation.


Forum|alt.badge.img+4
  • Navigator | Tier 3
  • 12 replies
  • March 29, 2023

Hi @Shoeb Shk ,

why doesn´t run?? can anyone advice me??

 

Thanks,

SOLVED: “c” & “v” must be in lowercase:

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings