I have a named range in an excel spreadsheet that is the last row of data and some forumulas, simplified it looks like this:
Acct1 Acct2 Acct3
2 50 200 100
3 150 375 25
4 75 20 125
5 =sum(a2:a4) =sum(b2:b4) =sum(c2:c4)
The range A4:c5 is named footer. Every day I go in and copy the last 2 rows down 1 row so that everything in 4 is in 5 and everything in 5 is in 6. then I go in and update the values in what is now row 5 to that days values.
I would like to automate this and in psuedo steps it would be
select range footer
set variable rangeStart = first cell of range "footer"
set variable rangeEnd = last cell of the range "footer"
goto rangeStart + 1 row (or move down 1 row)
set named range footer = rangestart+1row: rangeEnd+1row
save the file leaving it open
There will be lots more to do like opening serveral web sites to get the values and stick them in the cells, etc. but I’m brand new at uiPath and this would be the first thing that needs to happen.