I would like to be able to pull data after using a drop down list QTR1, QTR2, QTR3 and QTR4 - The data is located from 14 other tables each in a named tab, the 14 tables have a list of questions, and split up across the top QTR1, Comment, QTR2, Comment, QTR3 Comment, QTR4 Comment.
1 - Question - QTR1 - Comment - QTR2 - Comment - QTR3 - Comment - QTR4 - Comment
2. - Question etc....
This data on the KPI tab is "pulled" out of each tab, Column "QTR1" under this column is the data I need, but it must be pulled from each of the 14 tabs and populated into the KPI tab. Each time I select QTR2 or QTR3 from my dorp down list on the KPI tab etc... the KPI data changes accordingly - where does it land once it is pulled from the 14 tabs - I have 14 tabs with the heading of each tab at the top, the data populates under the respective Tab for the QTR it came from.
KPI TAB
LIST (QTR1,QTR2,QTR3,QTR4)
Column - Question - Albatross - Cresswel - (14 tabs across here)
1 - Question - Data here - Data here - etc.......
I am not sure what formula or code to use, youtube has not helped neither google searches. Any help would be useful
how do I add the excel spreadsheet for ppl to view?
Bookmarks