j_williams
11-05-2019, 08:34 AM
I have this array of data that I want to pull from.
25374
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)
25374
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)