I have a lot of membership data on on a seperate worksheet....(stuff like Admits, Admits/K, 7day readmits, 30 day readmits etc..
on my main sheet I have a dropdown with Region (central, west, SE, NE) and another dropdown with Product (Chronic Care, Institutional, and Dual - Eligible) want the user to select from the dropdown and have a seperate sheet populate with all of the data associated with their selection, so like I have done this with pivot tables previously, but now I am told we are not using pivot tables...
Best process ?
on my main sheet I have a dropdown with Region (central, west, SE, NE) and another dropdown with Product (Chronic Care, Institutional, and Dual - Eligible) want the user to select from the dropdown and have a seperate sheet populate with all of the data associated with their selection, so like I have done this with pivot tables previously, but now I am told we are not using pivot tables...
Best process ?