+ Reply to Thread
Results 1 to 31 of 31

creating a search functionality

  1. #1
    Registered User
    Join Date
    01-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    42

    creating a search functionality

    hi,
    i want that there should be a sheet in which i write a client name and click on search button ..then it should look up into all the sheets and display the entire rows in that sheet that contains the client name
    1.client name is present in column B in every sheet.

    please reply as soon as possible...please help

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: creating a search functionality

    You would like to locate the data or you would like to get it in the current sheet?


    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

  3. #3
    Registered User
    Join Date
    01-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    42

    Re: creating a search functionality

    i want it to get it into the entire sheet. and when i search for a new client name it clears the previous search and shows a new one...

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: creating a search functionality

    Please attach a dummy file with expected outcome for better understanding

  5. #5
    Registered User
    Join Date
    01-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    42

    Re: creating a search functionality

    in this the "search" sheet i have made that will explain you the whole need and please make it good accordingly and to make the box where client name to be put in.

    thanks..and reply if any issue.
    Attached Files Attached Files

  6. #6
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: creating a search functionality

    See attached.
    The search cell is B3, so you need to type your search word in B3. I am also assuming you want to search an exact match only
    Attached Files Attached Files

  7. #7
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: creating a search functionality

    Whether the company name will be available only once in each sheet or it will be present multiple times (On each sheet?)

  8. #8
    Registered User
    Join Date
    01-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    42

    Re: creating a search functionality

    the company name may be present multiple times.

  9. #9
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: creating a search functionality

    AB33 has already offered the solution to your question, please check

  10. #10
    Registered User
    Join Date
    01-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    42

    Re: creating a search functionality

    yes the solution is fine but not arranged as i have written please have a look at the search button and search data box i have assigned and the top most data present in every sheet that contains the description of data shown below..

    for example
    s.no,company,follow up date ,discription, etc etc..
    are u getting it to my point ??
    .please help.

  11. #11
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: creating a search functionality

    Yes, I saw it, but in your post # 1 display the entire rows in that sheet that contains the client name .
    I was not sure whether or not to copy an entire row, or few columns.
    I am still confused by
    "s.no,company,follow up date ,discription, etc etc.."
    What is etc?
    Could you please tell me which columns you want to copy, not with etc?

    It looks like 3 columns and when I run the code, it picked 3 columns too.

  12. #12
    Registered User
    Join Date
    01-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    42

    Re: creating a search functionality

    sir u are getting me wrong everything done till now is fine... simply telling i want the row 2 of every sheet to be displayed first and under this the searched row should come so that i should know that what the searched word describes

    s.no company first name last name description
    1. microtel a b done meeting


    did u get this now..the description of what is displayed should be seen ...

  13. #13
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: creating a search functionality

    Okay, Instead of copying the heading every time the code runs, why do not you copy it once in search sheet in row 6, or 7, so when you run the code and it find a match, it will copy the rows a-u which match with the heading in row 6.

    Insert this line on the above code and try it


    Please Login or Register  to view this content.
    After this line

    Please Login or Register  to view this content.

  14. #14
    Registered User
    Join Date
    01-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    42

    Re: creating a search functionality

    the description will change always as it is different in every sheet.can u do this : on finding the client name it pastes the row 2 of that particular list and then pastes the entire searched row of the data..it will be nice if can be done..

  15. #15
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: creating a search functionality

    Okay, I did not notice that. So, you want to copy the heading for every time the code finds a match. For e.g. on for "Microtel" Search, you want to copy the heading on that sheet to row 6 of search sheet and then display the result in next empty cell. Is this right before I correct the code?

  16. #16
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: creating a search functionality

    Try the attached
    Attached Files Attached Files
    Last edited by AB33; 05-03-2013 at 06:17 AM.

  17. #17
    Registered User
    Join Date
    01-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    42

    Re: creating a search functionality

    yes u get it... but see i have written the place where the heading is to be placed and the icon for search button and the search box also please assemble it as written .. name of client will be written in C1 instead of B3. and search button in d1 and the discription in row 3 and searched data in next row..

    thanks

  18. #18
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: creating a search functionality

    Okay. I have moved from B3 to C3 and button to D1. You can move, resize the button yourself, it does not require a code, just drag it.

  19. #19
    Registered User
    Join Date
    01-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    42

    Re: creating a search functionality

    yes u are right now..but also see that what i have added in "search sheet".the placement of a particular box the client name should be put in C1 not and the search box in D1 AND description to be put up in row 3 and after that the searched data....

    thanks for helping so much..

  20. #20
    Registered User
    Join Date
    01-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    42

    Re: creating a search functionality

    Thnks a ton please ignore the last comment .it was not showing to me the comment...thanks a ton will try and then reply.. :

  21. #21
    Registered User
    Join Date
    01-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    42

    Re: creating a search functionality

    Where is the file changed??

  22. #22
    Registered User
    Join Date
    01-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    42

    Re: creating a search functionality

    U havenot uploaded the file after making changes.. >???

  23. #23
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: creating a search functionality

    I do not want to download it 100 times, so post#16

  24. #24
    Registered User
    Join Date
    01-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    42

    Re: creating a search functionality

    thanks ..works fine.. :D

  25. #25
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: creating a search functionality

    Karanpreet,
    You are welcome!
    Could you please now close (Mark) this thread as solved? Go in to the top right-hand side of this page, choose "Thread Tools" from the menu, then select "solved" from the drop down menu.

  26. #26
    Registered User
    Join Date
    01-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    42

    Re: creating a search functionality

    hi please help i want the same search functionality that should show whole sheet on search .
    search will see the cell D1 of every sheet that has the client name and show that searched sheet in the sheet naming "Search"
    i am attaching a file for reference.

    2. i want that i should be able to search with date also that is present in "date of interaction" heading.for example i want to search the interaction that held between 20th jan 2013 till 2nd feb,2013 .then i should get the entire row displayed of the date that comes in between.hoping to get replied soon.

    thanks.
    Attached Files Attached Files

  27. #27
    Registered User
    Join Date
    01-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    42

    search the sheet and display

    hi please help i want the search functionality that should show whole sheet on search .
    search will see the cell D1 of every sheet that has the client name and show that searched sheet in the sheet naming "Search"
    i am attaching a file for reference.

    2. i want that i should be able to search with date also that is present in "date of interaction" heading in every sheet present for client.for example: i want to search the interaction that held between 20th jan 2013 till 2nd feb,2013 .then i should get the entire row displayed of the intraction that took place on that date that comes in between these mentioned dates.

    hoping to get replied soon.

    thanks.
    Attached Files Attached Files

  28. #28
    Registered User
    Join Date
    01-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    42

    Re: search the sheet and display

    why no one is responding to my issue... ?????

  29. #29
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: search the sheet and display

    Hi karanpreet,

    Have you tried to use the Find Options where you search the entire workbook for a name? It seems that is what you need.

    See http://www.dummies.com/how-to/conten...e-feature.html

    If you want a VBA Macro to do the task, you will need to give more information and a better example. VBA Macros are hard to build, even for us "guru's".

    I'd suggest you put all your data on a single sheet, in a table, and you could use AutoFilter or other normal Excel features to get what you want. Many times the way you structure your data allows answers to be easily obtained. Having lots of different sheets with a scattering of data makes this problem very hard.....
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  30. #30
    Registered User
    Join Date
    01-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    42

    Re: search the sheet and display

    just have a look at the sheet..the client name is present in cell D1 of every sheet .and i want that it should just look up the cell D1 of every sheet and if it finds the searched keyword then displays that whole sheet data in the sheet named "Search". just have a look at the file please..

  31. #31
    Registered User
    Join Date
    01-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    42

    Re: search the sheet and display

    i have created the format in sheet naming "search" as where to put the search button and to enter the data . my need is simply to see the cell D1 of every sheet and on finding it the whole sheet should get displayed in "search" sheet ...please help me doing so..

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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