Skip to main content
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.

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 


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.


Hi @Shoeb Shk ,

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

 

Thanks,

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

 


Reply