Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Oct 2007
    Location
    Beverly, USA
    Posts
    104
    Thanks
    0
    Thanked 1 Time in 1 Post
    I'm modifying a spreadsheet designed by a former colleague who's Excel skills exceed mine by a generous margin. I'm attempting to add to a drop down menu that she set up and I'm failing. I found the place in the spreadsheet where the data for the list was kept and added a few lines. This didn't work. I tried right clicking on the cell that has the drop-down and choosing "create list" from the shortcut menu, but the data for the list is in a separate tab and the "create list" function refuses to see any other tabs in the spreadsheet.

    What am I doing wrong?
    Attached Images Attached Images

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Try defining a named range and using that.

    See Named Ranges by Chip Pearson.

Posting Permissions

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