Getting problems while accessing data from Excel Sheet

[SNR]

Hi,
This is Narasimha, new to this group.
I am trying to access the data from two excel files in a single script by using two For loops. Main Excel sheet contains 6 rows and sub excel sheet contains only one row. (Here based on if condition for Main excel sheet each row in Main excel sheet should go to different sub excel sheets which contains only one row)

Code:

Main Excel Sheet(6 rows)
For Loop for Main Excel Sheet
   If Header is Yes in Main sheet
       Sub Excel sheet(1 row)
       For Loop for Sub Excel Sheet
       Next
   End If
Next

While running it is running fine for first row but Main sheet contains 6 rows thatswhy it is searching for 6 rows in sub excel sheet and throwing error messages.(I have also changed to one iteration only under Run tab).

Cany any one please help me in this.

Thanks and Regards
Narasimha