Hi All, We have data in excel, img for reference [image] i want to read total no of P for Rakesh and Purvi and write in another sheet and also want to calculate total no of leaves (L+H) for both, img for reference [image] please help with the logic.

Excel automation problem

Gresilda_Balla (Gresilda Balla) August 25, 2021, 1:48pm 3

I am sending you a short code that I think may help you.
BlankProcess9.zip (37.3 KB)

2 Likes

Forum Engagement Daily Reports

Topic		Replies	Views
REad Data row in Excel and count Help datatable , excel , activities , question	28	1778	February 1, 2020
How could i deal with the excel file problem？ add the row data Activities datatable , excel , activities , studio , question , excel-scope , excel-automation	17	587	December 29, 2023
Regarding excel Academy Feedback	9	1109	December 12, 2018
Sum of specific rows of a particular column and write in seperate tab Help	2	2189	July 16, 2019
Specific row count need to calculate and paste in another report Activities excel , activities	7	931	June 9, 2022