+ Reply to Thread
Results 1 to 1 of 1

Data Validation list that can be updated both way

  1. #1
    Registered User
    Join Date
    09-05-2010
    Location
    abu Dhabi
    MS-Off Ver
    Excel 2003
    Posts
    9

    Data Validation list that can be updated both way

    I have created a price book for my use, i have used named ranges as available on data sheet. Th validation is put on price sheet which are criterion dependent.

    Now i am trying to find a solution to update the data validation ( data sheet) while entering value from price sheet i.e i should not only be able to choose what is already been updated on the list but could also add on to it without updating it separately on data sheet.

    any help..... vba imbedded formula anything that would make my sheet perfect.
    thanks in advance.
    Attached Files Attached Files

+ Reply to Thread

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