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
Hi Mukesh. Try something like this:
Please Login or Register to view this content.
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.
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 Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
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
Hi FDibbins ,
Thank you for easy solution without vba. It's working fine.
Thank you.
Mukesh
Happy to help, its another case of keepingthings simpleBaed 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)
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
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks