Create dynamic sheets in excel

[pradnyajadhav0712]

Hello all,

Sample data:

I want to divide the Ranks with group of 10 Even and group of 10 odd.
It should automatically create a sheet like Group1Even for first 10 Even records and similarly Group1Odd for first 10 Odd records.

Group2Even for next 10 even records and Group2Odd for next 10 odd records.
similarly goes on for all available records and in future records can increase.

I want to do it with RE framework…

Thanks

[pradnya_jadhav]

Please provide me an answer

[HarishGnanakumar]

Even and Odd is based on Rank values or Row Index?

[pradnyajadhav0712]

Besed on Rank values