Results 1 to 2 of 2

Validating Column

Threaded View

  1. #1
    Registered User
    Join Date
    01-04-2007
    Location
    India
    Posts
    12

    Validating Column

    Hi all,
    In one Worksheet say Sheet1 I have 2 Columns namely Item No & Description with Data(rows).
    In another worksheet i have the same 2 columns. My query is When i insert Item no in the second worksheet the Description Column should Validate itself from the data in the 1 st worksheet.

    For Example
    1st Worksheeet i have

    Item No. Description
    Item1 First Item
    Item2 Second Item


    So if in the second worksheet if i enter Item1 Under Item No Column the corresponding Description cell should filled with "First Item" as value automatically.
    How can i achieve this?
    Last edited by raul09; 10-19-2010 at 12:05 AM.

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