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.