How to call one excel for each loop to another excel for each loop

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?

Payroll.zip (17.5 KB)

@Raja.G,

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

@sarathi125

I used “For Each row”

@AshwinS2

Yes i used read range both of them

Hi @Raja.G

What is ur requirement

Thanks
Ashwin.S

@AshwinS2

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 :slight_smile:. 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