I’m having trouble trying to summarise data from multiple sheets into a new sheet. For example, payroll, in which there are multiple months and multiple employees. Is there a way to summarise all data from different sheets(months) into another sheet(payroll summary) for each employees displaying each month row by row?
Welcome to the community
You can use the following
- Use excel file and give the file
- For each sheet in excel
- Inside loop use reqd range and then merge datatable
- After the loop write the data to different excel or sheet
Hi, thanks for the reply. I’m new to UiPath. Can you help to explain what it means to give the file and merge datatable?
Welcome to UiPath forum
Are you looking for something like this
How about the following?
Percentage divison and rank data.xlsx (12.4 KB)
BlankProcess14.zip (74.1 KB)
Hope this helps!!
Hi! This really helped me. Thank you so much!
If you find the solution. Please mark it as solution to close the topic.