Selecting range of data based on values in a particular column
January 29, 2009 11:02 AM Subscribe
ExcelFilter: How can I select a range of data using VBA in Excel based on the values in a particular column?
posted by squorch to computers & internet (3 answers total) 2 users marked this as a favorite
I've got a report that exports its data to excel in 4 columns: Name, Crew Station, Hours in last 30 days and Hours in last 60 days. Crew Station, located in Column B, has two values: PILOT and AIRCREW. The macro sorts the data by Column B, with PILOT rows on top and AIRCREW values on bottom. I want to select the AIRCREW range of data (all four columns) only.