Pull rows from array given two conditions

[j_williams]

I have this array of data that I want to pull from.
for vba.PNG

I want to create a new table only containing the rows that are Area C and are Status: Active. I also want this new table to only show Task, Cadence, AssignDate, CompleteDate.

How can I write VBA code for this?

(I know PowerQuery can help this however I need to make a macro)

[Artik]

A fairly simple solution.
1. Filter the table by the Area and Status fields.
2. Using SpecialCells(xlCellTypeVisible) copy the table range to a new sheet.
3. Delete unnecessary columns.

Artik