Code:
Column A Column B Column C Column D Column E
Row 1 Batch No. 78
Row 2 some text-1A 89789879
Row 3
Row 4 some text-1A 89789879
Row 5
Row 6 Batch No. 75
Row 7 some text-2A 42343243
Row 8
Row 9 some text-1B 42343243
Row 10
this thing will happen for each batch no.
if "text-1A" is found in both rows (for batch 78 row2 n row4 ) then column D (row 2 n row 4) = 89789879(for batch 78).
how to do it using vba code? may be 1 loop inside another loop and using Find Method etc. not sure. anyone can show some light?