Rubiks
05-17-2010, 11:26 AM
Hi there, new to the forum. Hopefully can receive some much needed assistance!
I am trying to do an advanced filter with a Data Validation List on a set of data. Have spent hours looking about online and found a VBA example close to what I would like (attached zip file). Having no VBA experience means I am having problems editing this.
I have attached a draft model of what I am hoping to achieve (Example Sheet .xls), Basically I have my Lists and raw data on the second tab and what I would like to do is adjust cells B2, E2 and H2 so that from A5:F20 will display the filtered data. Is this at all possible?
Alternatively could the zipped example be replicated with just the Date of Return Field and have the results sorted by Business area, and then by division? So if I looked up May 2010 I could see the absences sorted by Business Area, and then Division?
Any help would be immensely appreciated! Thanks in advance.
I am trying to do an advanced filter with a Data Validation List on a set of data. Have spent hours looking about online and found a VBA example close to what I would like (attached zip file). Having no VBA experience means I am having problems editing this.
I have attached a draft model of what I am hoping to achieve (Example Sheet .xls), Basically I have my Lists and raw data on the second tab and what I would like to do is adjust cells B2, E2 and H2 so that from A5:F20 will display the filtered data. Is this at all possible?
Alternatively could the zipped example be replicated with just the Date of Return Field and have the results sorted by Business area, and then by division? So if I looked up May 2010 I could see the absences sorted by Business Area, and then Division?
Any help would be immensely appreciated! Thanks in advance.