+ Reply to Thread
Results 1 to 2 of 2

Giving suggestion list while typing

  1. 01-25-2013, 01:02 AM #1
    olivarsham
    olivarsham is offline
    Registered User
    Join Date
    01-15-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Giving suggestion list while typing

    I have list of items in 'Sheet1' - Column A. When I type in 'Sheet2' - Column C, I need that Items in 'Sheet1-Column A' should come as suggestions.
    The user will select a item from that. The user is not allowed to type/select items other than in 'Sheet1'. How to do that?
    Reply With QuoteRegister To Reply
  2. 01-25-2013, 01:11 AM #2
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Giving suggestion list while typing

    Refer the below links to know how to do it

    http://www.exceldigest.com/myblog/20...rop-down-list/

    http://office.microsoft.com/en-in/ex...001044864.aspx


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved

    If the suggestion helps you, then Click *below to Add Reputation
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1