Results 1 to 4 of 4

Drop Down Lists: how to make source from different worksheet

Threaded View

  1. #1
    Registered User
    Join Date
    03-14-2009
    Location
    Indiana
    MS-Off Ver
    Excel 2003
    Posts
    41

    Drop Down Lists: how to make source from different worksheet

    When creating a drop-down list using Validation, is there any way to make the source a different worksheet in the workbook? Right now when I click on Source and select my list, it will not allow me to go to another worksheet. If I manually enter a reference to cells in another worksheet, such as 'PCP'!$A$2:$A$250 it only shows that cited reference, not the actual list.
    Last edited by HarvardMajesty; 05-15-2009 at 04:38 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1