I am new in the RPA journey, so I kindly ask your support on solving an issue with an Excel file, that I have to report every day.
I need to append the data (which are measurements generated by a .csv file) every day and after the measurements are appended on excel, I have to make the sum of the row. I have managed to perform the append activity, but I am facing problems to make the sum of the row, because the cell that needs to be written the sum is dynamic, not a specific one.
I can not upload the file because of security reasons, but I have uploaded a structure of it.
Thank you in advance and your support would be very appreciated!
Dynamic Cell Sum.xlsx (8.5 KB)