Issue with Looping Filtered Range of Visible Cells

[Vinod Krishna.C]

Dear all,

I'm trying to loop through Filtered Range of Visible Cells. Unfortunately, I'm just able to

I'm looping through names of players ( Players sheet) and mapping their clubs (Player sheet).

The mapping just doesn't seem to work for 1st row of data (except header) i.e for Player " B "

PFA for sample data.

Here's the code logic.

Please Login or Register  to view this content.

Appreciate your help in correcting me and helping me understand the mistake.

Thanks,
Vinod Krishna

[xladept]

I made a couple of changes to your code:

Please Login or Register  to view this content.

*BTW - The player sheet didn't have "Player" for a heading - I also had to change that for the program to run