+ Reply to Thread
Results 1 to 9 of 9

Search number quickly

  1. #1
    Forum Contributor
    Join Date
    12-15-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    672

    Search number quickly

    Dear friends,
    I have serial numbers in column 'b' range 'b8:b5007' from 1-5000. I have to edit the data sometimes. I want to do it by quickly searching the serial number of that entry in a single click to save my time. Can you please suggest me a macro to perform this action in a single click quickly?

    I want to enter the search serial number in a search box and then in a single click go to that particular number is my requirement. Do suggest me acode for it.

    Thank you in anticipation.

    Mukesh
    Attached Files Attached Files

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,825

    Re: Search number quickly

    Hi Mukesh. Try something like this:
    Please Login or Register  to view this content.

  3. #3
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Search number quickly

    Hello mukeshbaviskar,

    The attached workbook has the following macro installed. There is a button at the top of the worksheet to call it. Rows 1 to 7 are frozen so the headers remain visible while you scroll down the list. If the requested serial number can not be found, the macro will inform you. You can also add more serial numbers without changing the macro.

    Find Serial Number
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

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

    Re: Search number quickly

    Another option that does not require VBA is to use the Find/Replace in excel. press CTL H, enter the number, tab, enter the replacement - done
    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

  5. #5
    Forum Contributor
    Join Date
    12-15-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    672

    Re: Search number quickly

    Hi FDibbins ,
    Thank you for easy solution without vba. It's working fine.

    Thank you.

    Mukesh

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

    Re: Search number quickly

    Happy to help, its another case of keepingthings simple Baed on your last post, it seems this answered your question, so please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)

  7. #7
    Forum Contributor
    Join Date
    12-15-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    672

    Re: Search number quickly

    Hi Mumps1,
    Thank you. It's working fine but one little problem is that the cursor didn't go to that particular cell in which the number is. Only the page scrolls and shows the number. I want to select the particular cell in which the number is.

    Please do this revision.

    Thank you.

    Mukesh

  8. #8
    Forum Contributor
    Join Date
    12-15-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    672

    Re: Search number quickly

    Hello Leith Ross,
    Excellent! It's working fine. I need a little modification in your code to meet my requirement as follows:

    After clicking on 'ok' the cursor should go to that particular cell in which the number is. At present the page scrolls and display the search number but the cursor didn't go to that cell.

    Everything else is very correct. Please do this amendment in the code to meet my requirement.

    Thank you.

    Sincerely,

    Mukesh

  9. #9
    Forum Contributor
    Join Date
    12-15-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    672

    Re: Search number quickly

    Hi Leith Ross,
    I have added a line at the end of the code to move the cursor to that particular cell. Now my problem is solved.

    Thank you very much for guiding me to solve my problem.

    Thank you to all of you.

    Sincerely,

    Mukesh
    Attached Files Attached Files

+ 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. auto enter number macro then search for rest of number
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2013, 04:24 PM
  2. [SOLVED] search for text, then search for previous text, replace 1st text including number from 2nd
    By kldailey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-06-2012, 05:23 PM
  3. [SOLVED] Search in a row for a column number after a Vlookup search.
    By Fiebuls in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-11-2012, 04:25 AM
  4. need help quickly!!
    By alexm999 in forum Excel General
    Replies: 3
    Last Post: 02-28-2006, 10:42 AM
  5. [SOLVED] How do I quickly enter the same number into different cells?
    By Cheers100 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-18-2006, 10:30 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