Hello,
I have been working on trying to automate copying all rows from all sheets in my Excel Workbook to one sheet (ActiveSheet). I was able to get the flow to copy the data but it would only copy it to one row in ActiveSheet and then overwrite it with the next data copied over.
I want the data to be copied to Row 2 (LastRow) on ActiveSheet and then after that copy is completed I want to add 1 to LastRow (making it 3) so that the next row does not overwrite to the previous.
This is the flow I have, it ran for 12 hours, I was so hopeful but then there was nothing copied into my ActiveSheet. All of my Variables are being set and it looks like it is progressing correctly but I am not sure what I am missing to get the data to copy over.
Any help or advice would be wonderful! Thank you in advance