I'm not sure if this has been asked before. I am trying to use 2 comboboxs, combobox 1 that is fill with the titles of the pivot tables and combobox 2 which is pulled from the pivottable named in combobox one. I have 5-6 pivot tables on sheet1 and the combo boxes are on the worksheet "Information". I'm doing it this way to keep out duplicates and blanks. Can this be done? Its supposed to do a search in the long run. Unless there is some easier way I'm missing. Thanks so much. I'm also a bit of a novice at VBA but I'd use it any day!
Bookmarks