Here is an excel sheet shared
Ledg.xlsx (15.4 KB)
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.
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.
so, you want to add a formula into a cell, right?
In this case, this post should help you:
I m trying to make UiPath run an if Function in the Field E3 in Red Frame).
The If fuction to run is :
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…
@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 .
Is those data are fixed cells?
You can try with below post for your reference
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–
You can set the value in datatable if you have specific location
Hope this helps you