Hello -

I am trying to automate a query process. I have an Excel pivot table with 6 columns. The underlying detail data consists of 24 columns and 3500 rows. Following these two workbook tabs, I have about 15 forms, each on a separate tab.

Each record contains a unique index number. Is there a way when the user is in the pivot table and clicks on the index number, that I could capture that number?

I'd like to automate it so that when a user selects an index number, it would put them in the correct form (which is hyperlinked in the detail data), and then autopopulate some fields from the detail data (maybe through a vlookup of the Index number in the detail?)

Thanks for your help.