Incell drop down list

[Sadik]

HI All,

I want to get the list of all worksheet tab's name in
another workbook in an Incell dropdown list. Worksheets
get added and deleted. How can I do this?

Thanks for your help.

Regards

Sadik

 

[Frank Kabel]

Hi
one way:
- in your other workbook you have to create a list of all your
worksheet names. See http://www.mvps.org/dmcritchie/excel/buildtoc.htm
for creating such a list

- now you can use 'Data - Validation' accessing this list. How to do
this with a list from another workbook is described at:
http://www.contextures.com/xlDataVal05.html

 

[Sadik]

Thanks Frank.

Sadik

-----Original Message-----
Hi
one way:
- in your other workbook you have to create a list of all your
worksheet names. See http://www.mvps.org/dmcritchie/excel/buildtoc.htm
for creating such a list

- now you can use 'Data - Validation' accessing this list. How to do
this with a list from another workbook is described at:
http://www.contextures.com/xlDataVal05.html


--
Regards
Frank Kabel
Frankfurt, Germany



.