Drop Down List.. with a Twist

  • Thread starter Thread starter John
  • Start date Start date
J

John

Is it possible to have a drop downlist of Sheets within a file, that is
dynamic i.e. everytime you add a new sheet this would also appear in the
Drop Down List. I suppose its kinda like a Dynami Range except that range is
the actual sheet's themselves

Thanks
 
Just found this formula in the newsgroup which will return the sheet name in
a cell

=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)

I suppose I can now just create a dynamic range on this column then create a
Drop Down from that
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop-down list and error message 1
Drop down list from index/match formula 1
Dymanic List Range 2
Dependent drop down dynamic range formula, off sheet. 7
Data Validation and drop-down list using IF, AND and what else? 8
Drop Down List 2
Drop Down with dynamic named range offsheet source list 14
drop down list 1

Back
Top