Looked at other posts, but didn't find much help. Not a VB power user.

Need macro that will look within Sheet 1 first row at cell in specified column and then insert a row in sheet 2 if condition is met (ignore and go to next row if not). Contents of new sheet 2 row should contain only specified cells from sheet 1 row. Then go to next row and repeat. Finish when all rows that contain content are checked.

Thanks in advance!