I am stuck on a macro. I am trying to use a data range that might change in number of cells used on sheet 1 as a driver to match to a set of values in a column (which might also move locations) as it comes out of a reporter that is used differently by each end user. If the values of the range on sheet 1 match and sheet 2 i want those rows hidden so that only the rows that match show, if the value shows up twice on sheet 2 (isn't unique) choose the first one. I have used a search to find the row that i need to identify the column regardless of the location move for sheet 2, but i can't get the hide loop down. This is what i have. Any help you provide would be appreciated.
'Sheet 1 data range but again this length could change
Set Fin = WST.Range("B7:B15")
' first line of data*.
actC.Select 'starts from J3 on data sheet actC is the result of the search parameter
' Set Do loop to stop when an empty cell is reached.
Do Until IsEmpty(ActiveCell)
If ActiveCell.Value = Cells(Fin, 2).Value Then 'causes mismatch error
Fin = Fin + 1
ActiveCell.EntireRow.Hidden = True
' Step down 1 row from present location.