I have a workbook with a summary sheet and multiple additional sheets (monthly) which contain numerical data. Each monthly sheet is formatted identically, but had the ability to be sorted. I have created names for each row and column.
What I want to do is use indirect to reference the sheet name using a dropdown on the summary sheet and pull data from the chosen sheet by referencing the row/column name.
I have successfully added the dropdown, and used indirect to choose the sheet name.....I am also able to use indirect to pull the row/column amount if I do it on the sheet the data is in, but I have not been able to get my formula to work to both pull the sheet name from the drop down AND the referenced names on the chosen sheet within the summary sheet. I can do it if I hard code cells, but I am wanting to use the names so that it works regardless how the sheet is sorted.
Any help?
Thanks
Bookmarks