+ Reply to Thread
Results 1 to 4 of 4

how to make a cell, detect the data we type and search from a group of data selected

  1. #1
    Registered User
    Join Date
    05-20-2016
    Location
    Malaysia, Selangor
    MS-Off Ver
    2016
    Posts
    1

    how to make a cell, detect the data we type and search from a group of data selected

    sorry if i post in the wrong group as im new here, but im having issues that is taking too much of my time just repeatedly keying in the same data on one sheet based on a group of data, so i would like to know how to make a cell, detect the data we type and search from a group of data selected and auto fill in the rest of the data in other cells..would that be possible?

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: how to make a cell, detect the data we type and search from a group of data selected

    Yes it can, but

    1. It would help to see the workbook.

    You get better help on your question if you add a small excel file, without confidential information.

    Please also add manualy the expected result in your file.

    To Attach a File:

    1. Scroll down to the window below your post Additional Options
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Banned User!
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: how to make a cell, detect the data we type and search from a group of data selected

    It depends on your sheet layout.

    Excel will auto-complete from other entries in the same column, going back to the last empty cell, anything above that empty cell will not be included.

    You need to type enough for an entry to be identified as unique, so if you have 2 entries where the first 10 characters are identical, then you would need to type 11 characters before autocomplete would take effect.

    Other than that, copy and paste, or maybe data validation.

  4. #4
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: how to make a cell, detect the data we type and search from a group of data selected

    I hate typing!

    I use this technique in many of my personal files.

    When I need to enter the same data on a repetitive basis, instead of typing I use drop down lists to select the data to be entered.

    See this...

    http://www.contextures.com/xlDataVal01.html
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Need to type the code to make a button that will copy data into next clear line below
    By stevelock92 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-06-2015, 08:58 AM
  2. [SOLVED] type in a search tab and search the data in another tab(and Delete)
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-10-2013, 09:27 AM
  3. How do I detect the cell data change?
    By Deladier in forum Excel General
    Replies: 4
    Last Post: 10-03-2012, 09:29 AM
  4. Formula to Detect Last Cell in a Column with Data Entered
    By TylerJamison in forum Excel General
    Replies: 5
    Last Post: 06-29-2012, 03:52 PM
  5. Search Selected Data for a Text String and replace entire cell with new tex
    By maz003 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-06-2010, 02:26 PM
  6. Detect when cell data has changed?
    By excelbobabc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-16-2009, 11:50 AM
  7. [SOLVED] Lookup Oldest date from previously selected Group Data
    By Jim May in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-14-2005, 03:06 PM

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