+ Reply to Thread
Results 1 to 2 of 2

Search data on another sheet

  1. #1
    Registered User
    Join Date
    04-13-2020
    Location
    Philippines
    MS-Off Ver
    2013
    Posts
    29

    Search data on another sheet

    Hello! Just want to ask if it is possible for me to use a search function in excel? So, as you can see in the attached file, I have a search area in the HOME sheet. I like to use it and get the data on the STUDENTS INFO sheet then after clicking the search button, data will be displayed on the HOME sheet. Is that even possible in excel? If yes, can someone help me with it? Thank you in advance!
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,615

    Re: Search data on another sheet

    You dont need to press "search", this option will automatically pull in the data as soon as you enter an ID

    1. All the experts here advise against using merged cells, they cause all sorts of problems and are seldom necessary - rather, just widen your columns.
    2. Keep the headings the same in both tables, you have "NAME EXTN." and "NAME EXT." Pick 1 and use that.
    3. Try this formula...
    D8=INDEX('STUDENT INFO'!$B$5:$F$7,MATCH(HOME!$E$5,'STUDENT INFO'!$B$5:$B$7,0),MATCH(HOME!B8,'STUDENT INFO'!$B$4:$F$4,0))
    copied down and across as needed.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Replies: 10
    Last Post: 07-02-2020, 12:45 PM
  2. [SOLVED] VBA to search internet and copy data into sheet based on search
    By DanzaNZ in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-03-2016, 06:17 PM
  3. Search column in sheet to match data in another sheet issue
    By mattyp in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 01-23-2015, 09:39 AM
  4. Replies: 4
    Last Post: 09-05-2012, 05:57 PM
  5. [SOLVED] Search for heading in data sheet and copy range to corresponding sheet in master workbook
    By sans in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-07-2012, 10:02 AM
  6. Macro to search the sheet name and copy and paste the data from a major sheet
    By salma2009 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-04-2009, 02:11 AM

Tags for this Thread

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