Moving cell values elsewhere within Excel

Jeavo

New Member
Hi

Could anyone advise me on how I'd move a block of cells elsewhere on my spreadsheet?
For example I would like to move A64 - A126 to B1 to B63.
Thanks
 

Umuruk

New Member
Automation anywhere has $Excel Cell Row$ variable. It shows your focussed cell's cell number

You can use excel cell row variable with go to specific cell option

For example

variable operation mycell = excel cell number
if excel cell number =< 63
go to cell b$mycell$
variable operation $mycell$ = $mycell$+1
else
go to cell a$mycell$
variable operation $mycell$ = $mycell$+1
endif
 
Top