Sheet 'A' has cell index till DM200. I want to pull the data from of these
rows in Sheet 'B' only when column DM of that row in sheet A says "PAST".

I do not want to pull rest of the data. The data gets sorted everyday, so
the"PAST" can be in any row of column DM.

Thanks for you help.
NM