PDA

View Full Version : Interactive Drop Down List/file chooser



Gusty
06-17-2010, 03:05 AM
Hi there - I have a large amount of test results held in separate excel files ( 1000+ !). I am trying to set up a single comparison file which will compare any two products against each other. see attached file. product names are on left hand side and subcategories within each file are along the top ( on separate tabs within the individual data files ) I am trying to do some sort of interactive drop down list where i can choose the subdata files to compare and then maybe use offset function to pull in the data once the files are picked from the drop down list. However am having trouble sorting out a drop down list to choose the individual excel files. Perhaps this is not the best way of doing it, so I would really appreciate some help on this