Hi everyone,
Hope everyone had a great new years!
I'm trying to set up a function that uses data from a different cell to designate what sheet in the workbook to look to for more data.
Example would be I have 10 sheets of sales data for a company. On a separate sheet I have a complex function that need information from 4 of the 10 sheets of sales data at a time. These 4 sheet change from time to time, so I wanted to create a drop down menu with the names of the 10 sheets in it and have the sheets' names plug into the complex function. Let me know if this is unclear and I'll come up with an example.
Thanks everyone!
Hope everyone had a great new years!
I'm trying to set up a function that uses data from a different cell to designate what sheet in the workbook to look to for more data.
Example would be I have 10 sheets of sales data for a company. On a separate sheet I have a complex function that need information from 4 of the 10 sheets of sales data at a time. These 4 sheet change from time to time, so I wanted to create a drop down menu with the names of the 10 sheets in it and have the sheets' names plug into the complex function. Let me know if this is unclear and I'll come up with an example.
Thanks everyone!