Hello all, I know that a list of worksheet names can be used to create a dropdown list, but is there a method without using VBA (because my manager is a clown) that would allow the dropdown list to refer to the actual sheet names and not refer to a list of sheetnames? The reason I don't want to create a list is because there are a lot of them (in different workbooks too) and they change frequently - I would spend more time keeping the list updated than on anything else.
The setup would be:
A1 - a dropdown list that the user selects an item (this refers to one of several workbooks) - I can do this bit easily.
A2 - a dropdown list that contains the names of all the worksheets in the workbook at A1. I can create a list of all the worksheet names, but I would realistically need this dropdown to refer to the actual spreadsheet names and not a list of them.
A3 - a vlookup that gets the value of a particular cell in worksheet at A2.
I hope that makes sense. I suspect the answer will be that it can't be done but if any genius can help it'd be really appreciated.
Thanks.
The setup would be:
A1 - a dropdown list that the user selects an item (this refers to one of several workbooks) - I can do this bit easily.
A2 - a dropdown list that contains the names of all the worksheets in the workbook at A1. I can create a list of all the worksheet names, but I would realistically need this dropdown to refer to the actual spreadsheet names and not a list of them.
A3 - a vlookup that gets the value of a particular cell in worksheet at A2.
I hope that makes sense. I suspect the answer will be that it can't be done but if any genius can help it'd be really appreciated.
Thanks.