Hi,
I am looking for away to use a dynamic range for an advanced filter that will update the "list Range" based off of a drop down list. For example, i have 4 worksheet for the months of Jan through April. I need the advanced filter to look at data in a specific sheet based off a drop down list of months. So if Feb is selected, the advanced filter will look at the FEB data tab and filter from there.
Any help would be appreciated
I am looking for away to use a dynamic range for an advanced filter that will update the "list Range" based off of a drop down list. For example, i have 4 worksheet for the months of Jan through April. I need the advanced filter to look at data in a specific sheet based off a drop down list of months. So if Feb is selected, the advanced filter will look at the FEB data tab and filter from there.
Any help would be appreciated