-
Pull rows from array given two conditions
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)
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules