LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Create a drop down list in Excel with 2 different work sheets

In worksheet A I have defined a drop-down list (source). Now I want to use
this list in around 20 other Excel worksheets. If I want to add the function
with the data validation in worksheet B I always get an error message.
Any idea if there is a solution for this or it is a bug? (Of course if I
copy the data source list into each worksheet it is working).

Thanks for your reply in advance!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I create a drop down list with a calendar in excel claron Excel Worksheet Functions 1 February 7th 08 08:59 AM
A user says he can't get my drop down list to work in Excel. Keli Excel Discussion (Misc queries) 1 April 26th 05 08:22 PM
How do I create a combo drop down list in Excel? Ron Excel Worksheet Functions 1 April 15th 05 08:29 PM
How do I create a drop down list in Excel 2003 Lenny Excel Discussion (Misc queries) 1 February 17th 05 09:26 PM
Is there a way to create a drop-down list of links in Excel? t_boden Excel Worksheet Functions 1 February 3rd 05 06:14 PM


All times are GMT +1. The time now is 10:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"