How do summarise multiple datas from different sheets into a new sheet?

Help StudioX
, , ,
1

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?

2

@desperATE

Welcome to the community

You can use the following

  1. Use excel file and give the file
  2. For each sheet in excel
  3. Inside loop use reqd range and then merge datatable
  4. After the loop write the data to different excel or sheet

Cheers

3

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?

4

Welcome to UiPath forum

Are you looking for something like this

Cheers @desperATE

5

Hi @desperATE

How about the following?

image
image882×1796 59.8 KB

O/P:

Percentage divison and rank data.xlsx (12.4 KB)

BlankProcess14.zip (74.1 KB)

Hope this helps!!

6

Hi! This really helped me. Thank you so much! :slight_smile:

1 Like
7

@desperATE
If you find the solution. Please mark it as solution to close the topic.

Happy Automation!!