VBA - Filter Data based on criteria

[Reji Rajan]

Hi,

I am trying to make a report where the data pasted in sheet 1 is filtered as 2 criteria & the resulting data is pasted on sheet 2. I have managed to get data on sheet 2 with vba but only based on criteria 1. Sheet 1 has data from column A to Column N with the number of rows fluctuating. The conditions are as mentioned below:
criteria 1: If any cell in column M has text (have used IS TEXT)then the entire row gets highlighted with RED color.
criteria 2: if any cell in column A begins with "BB" (have used LEFT (A1),2), then the entire row gets highlighted with yellow color.

The resulting data with red & yellow color gets pasted in sheet 2.

Any advice or suggestions will help.

I have attached sample worksheet for reference.

Cheers!!
RJ