Excel 1 and excel 2 both have “For each loop”, i need to call excel 1 “For each loop” to excel 2 “for each”.
Please can anyone help this?
Excel 1 and excel 2 both have “For each loop”, i need to call excel 1 “For each loop” to excel 2 “for each”.
Please can anyone help this?
Your question is not clear, do you want to call the excel 2 inside for each
Are you using for each row or For each?
Hi @Raja.G
Use read ranges for both Excel and then use for each row in Excel 1
And for each row in second Excel
Then check the condition
Thanks
Ashwin.S
I need to process the payroll , excel 1 i will calculate the emp leave to apply the excel 3 for salary detection based on leave
It’s not possible to give you a solution with the above explanation @Raja.G . How you are summarizing the data for each employee in the excel? So grouping the employee numbers, you have to identify how many leaves they applied in that month and based on the number you have to deduct the money right?
My question is, how you are trying to summarize the leaves for one particular employee in the excel sheet? To give you an idea of this requirement, I would suggest doing a pivot table of the excel 1 you have so that you will get the count of leaves