Hello,
Hoping that someone can help me on this as I am working on a huge amount of data right now. So to beat the deadline, I would want to make everything easy by using a VBA code that would hide a row based on a VLOOKUP/HLOOKUP result (or other alternatives).
There are two sheets present, 1 is the masterlist of lots, while the 2nd is the sold lots list. I would like to make a more easy approach that whenever the PHASE BLOCK and LOT matches the one on the masterlist will automatically hide the matched row.
Thank you in advance.
Hoping that someone can help me on this as I am working on a huge amount of data right now. So to beat the deadline, I would want to make everything easy by using a VBA code that would hide a row based on a VLOOKUP/HLOOKUP result (or other alternatives).
There are two sheets present, 1 is the masterlist of lots, while the 2nd is the sold lots list. I would like to make a more easy approach that whenever the PHASE BLOCK and LOT matches the one on the masterlist will automatically hide the matched row.
Thank you in advance.