I have a shortage report generated daily by the company server. It has
PartNo (Col A), Owner (Col B), Comments (Col C), Qty (Col D). Part numbers
will only appear in this file if qty falls below certain value.

I already have a macro that can filter the daily shortage report by owner
(which is my name). Based on the filtered list (all part numbers that belong
to me), I will update the comments column.

Now I created a master file with all the part numbers that I need to take
care of. It has 2 columns: MyPartNo (col A) and Comments (col B).

I also created a macro that can match the PartNo in shortage report to
MyPartNo in my master file, copy the comments I enter earlier in shortage
report and then paste it to Comments column (Col B) in my master file. But
this macro still check all PartNo in the shortage file despite it's filtered.

How can I write the macro in such a way that it only match/look for the
PartNo based on the filtered list, but not every single part number in the
whole shortage report? This will reduce a lot of macro processing time.

choo