0
Undo
Votes
Hi, All the expert people out there.
I am stuck in a problem and have tried lots of option but no success.
I have two wheets in one worksheet and I am comparing 2 coulmns to retrieved the value from one into another. screenshot attached
The problem is that the sheet I am retrieving the value from have 2 blank rows and have to skip them.
I am not able to skip and retrieved the right value when ever a blank row is there.
please advise
I am stuck in a problem and have tried lots of option but no success.
I have two wheets in one worksheet and I am comparing 2 coulmns to retrieved the value from one into another. screenshot attached
The problem is that the sheet I am retrieving the value from have 2 blank rows and have to skip them.
I am not able to skip and retrieved the right value when ever a blank row is there.
please advise
There are no replies made for this post yet.