-
Interactive Drop Down List/file chooser
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules