Hi,

I have a list of customer contacts that are both active and inactive (indicated by column A as "Y" for Inactive or "N" for Not Inactive) in Sheet1. I'm trying to find a way to have Excel do an iterative query on the value in column A such that if the cell value for A2 = N, it will copy the associated row of data into another worksheet, Sheet2. If A2 value = Y, then skip that row, and perform the query on the next row, A3 to see if the value is N or Y.

Complications:
- All my data in this worksheet are linked from different files in the same directory as they are dynamic and liable to change, so I don't want to move, re-organize, manually manipulate any columns
- I'm working with +14000 rows of data, so something automated (formula? macro?) would be required

I've used IF() to return data in my Sheet2, which does only filter the active customers, but then for all rows where the value in column A = "Y" only show up as blank rows. I need a block of data without any gaps between them. Is there any way to do this? Any help would be extremely appreciated! I'm not well versed in VBA, but would be willing to experiment and learn if I had some guidance!

Thanks!