Results 1 to 2 of 2

Best way to validate these cells?

Threaded View

Riknos Best way to validate these... 08-14-2008, 07:35 AM
NBVC I'm not sure I understand...... 08-14-2008, 07:56 AM
  1. #1
    Registered User
    Join Date
    08-14-2008
    Location
    England
    Posts
    1

    Best way to validate these cells?

    Hi there, I need some advice as to which would be the best way of proceeding.

    I'm trying to set up a spreadsheet that will only allow certain entries in certain fields. For example, first column is 'C reference' and the only available options are C3, C6 & C8. For this, I have used Validation to pick these from a list that is listed in the top 3 cells above the first column, and these rows are hidden. This works fine. However, I now need the 'Switch' column to display about 25-30 choices in a drop down box. I could do this a similar way, but I don't think it will look so professional. Any advice what would be the best way of doing this would be grand, cheers.
    I've attached a copy of the document so you can understand what I'm going on about.
    Thanks.
    Attached Files Attached Files

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