July 11, 2017
I have created attached and tried to make interactive without using Power Pivot.
On Group Report tab, first select required group from dropdown in cell A2, this brings up a list of all sites within that group in column R. Column R has a hyperlink to take you to Site Report tab. each time the group is changed a new list of sites appears in column R
My issue is I would like that the Site selected in column R automatically appears in cell A2 on Site Report tab rather than having to manually select the Site.
Is this possible?
July 16, 2010
I don't see how you can choose a single site based on the group selected in the Group Report as groups have many sites. What is the logic Excel should use to choose one site from a list of many?
Also, this report structure is precarious. None of the data sheets are in the correct Tabular layout, which is forcing you to use formulas that are overly complex, and many of which are already broken (#REF errors). Even if you don't want to use Power Pivot, I would still structure the source data correctly and format it in Excel Tables, as this will make your formulas easier to build and more robust.
July 11, 2017
Thanks for the reply, Unfortunately the data does not come to me in Tabula layout.
I am going to try and reformat the data into Tabula form and then try using pivot tables/charts/slicers
This post can be closed, I will raise a new query if I get stuck.