+ Reply to Thread
Results 1 to 6 of 6

Cell giving suggestions according to earlier typings in cells above

  1. #1
    Forum Contributor timtim89's Avatar
    Join Date
    01-05-2012
    Location
    Copenhagen, Denmark
    MS-Off Ver
    Excel 2010
    Posts
    141

    Cell giving suggestions according to earlier typings in cells above

    Hi! In my search for a solution for a problem, I found this thread:

    http://www.excelforum.com/excel-new-...453-names.html

    .. in which the attachment in #4 does exactly what I need to do myself. The thing is that I can't see how the outcome in the attachment in #4 is acheived. I have attached the file here, and it is highly appreciated if anyone can provide me with link, formulaname I can google, or someway else to find out how to:

    A) get suggestions in a cell according to the values in cells above (in the attachment happens in A6 and down).
    B) make excel functions not appear until the reference cell is filled (in attachment column B and C contains the formula and column A being the reference.

    Thank you for your help in advance.

    Timo
    Attached Files Attached Files
    Last edited by timtim89; 02-20-2012 at 06:08 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    12-16-2004
    Location
    Canada, Quebec
    Posts
    363

    Re: Cell giving suggestions according to earlier typings in cells above

    Hi

    you need to use a macro. put this code in vba sheet
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Denis

    Please always attach the sample workbook without sensitive information when asking for help

    To add a module
    Press Alt + F11 (this is the Visual Basic Environment)
    Insert Menu, select Module
    Past code there
    Close Visual Basic Environment (X)

  3. #3
    Forum Contributor timtim89's Avatar
    Join Date
    01-05-2012
    Location
    Copenhagen, Denmark
    MS-Off Ver
    Excel 2010
    Posts
    141

    Re: Cell giving suggestions according to earlier typings in cells above

    The thing is that in the solution in my attachment, the B and C columns contains actual formulas. And in case I want to change those formulas or apply same thing for another sheet or wb, it is far easier if I can avoid VBA coding if possible. I was guessing it should be, since there is no VBA (at least not visible) in my attachment. Sorry if I didn't say that before, and thanks for the help so far!

  4. #4
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,337

    Re: Cell giving suggestions according to earlier typings in cells above

    hello
    is the first query - auto complete..

    second query
    maybe display blank

    column B
    Please Login or Register  to view this content.
    drag down
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  5. #5
    Valued Forum Contributor gjlindn's Avatar
    Join Date
    08-01-2011
    Location
    Dodgeville, WI
    MS-Off Ver
    Excel 2003, 2007, 2010, 2013
    Posts
    369

    Re: Cell giving suggestions according to earlier typings in cells above

    Hello again Timo. The functions you're requesting are native Excel options. Formula AutoComplete can be turned on/off via Excel Options on the Formulas tab and Extend data range formats and formulas is on the Advanced tab. Does that answer your question? Thanks!
    -Greg If this is helpful, pls click Star icon in lower left corner

  6. #6
    Forum Contributor timtim89's Avatar
    Join Date
    01-05-2012
    Location
    Copenhagen, Denmark
    MS-Off Ver
    Excel 2010
    Posts
    141

    Re: Cell giving suggestions according to earlier typings in cells above

    Thanks Greg, that was the answer I was looking for
    vlady, thanks for your answer as well.

    Problem solved

+ 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