Take data from the master sheet and fill to the other sheets having some format and do the sum accordingly

[Swara_Soni (Swara)]

Here is an excel sheet shared Ledg.xlsx (15.4 KB)

In which Master Data sheet contains the master data and other sheets are created as per the Name(unique) in the master data.
The master data gets generated every month.

And the output will look like

In the above two images the thing happening is
Example- all the data of ID No - 18695 is putted into the new sheet Tatera- DNT.

Because master data gets generated ever month so i want the new data to be inserted in last row without overlapping and then sum is done for whole data in the last.

The SUM column in the sheet shows the sum of values of every month and while doing the sum of current month the last month data is also added as shown in the image above.

I don’t know how to insert the data like this and do the sum in the required manner.

Please help.

[RoboHeart]

Hi @Swara_Soni

so, you want to add a formula into a cell, right?
In this case, this post should help you:

If condition on EXCEL by using UIPAATH

Hi everyone, I m trying to make UiPath run an if Function in the Field E3 in Red Frame). The If fuction to run is : IF(E2>=365,“25”,IF(E2>=150,“15”,IF(E2>=53,E2*10%,IF(E2>=13,“5”,IF(E2>=5,“2”,“1”))))) sample|690x72 As you can see, the function is completely relying on E2, however, E2 is not a fixe number. It’s an extrapolation of E1, which is the population number, that may change depending on the userlist received. I could make UiPath calculate E1, and E2. However, when I type the IF fu…

[Swara_Soni (Swara)]

@RoboHeart thanks for the reply but i think you didn’t understand the whole situation …my main task is to extract data from master sheet and fill in other sheets then to add is another task…i am unable to achieve the first task .

Please help

[Srini84 (Srinivas)]

@Swara_Soni

Is those data are fixed cells?

You can try with below post for your reference

RPA DataTable: Get Previous Row Column Value, Set to Current Row Column Value

sorry i can not use this solution… As I want to Read Next row value before i continue to regiser the current row… my issue is When i have done reading current row through if statement … then I want to know… the next row Category before continue… And if there is no category or no row in table which has Category … then it should continue and register the current row in systerm… But it giving me error when it there is no row in system–

https://forum.uipath.com/t/tutorial-convert-number-to-date-format/249171/3

You can set the value in datatable if you have specific location

Hope this helps you

Thanks

[RoboHeart]

Sorry, my fault.