Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    May 2004
    Asheville, North Carolina, USA
    Thanked 0 Times in 0 Posts

    Validation Lists (Office 97)

    Greetings All,
    I am trying to create a validation list where the source is on another worksheet. The way I read the help file, I think it can be done, but I have had no luck.
    The reason for my list is so only those entries can be entered. I am dealing with account codes, want to make sure only valid codes are entered. These codes change every so often, and I would like to just change entries on one sheet ver. 25 sheets.
    Thanks for any help.

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Thanked 1 Time in 1 Post

    Re: Validation Lists (Office 97)

    You can use range names to accomplish this. In the data validation dialog you enter the range name in the source box, I have attached an example.

Posting Permissions

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