Find attached , need only codes to remain those 227.000.74 and so on
to appear on cell c without any rows
Yes I know I can highlight all data and sort and removed unwanted ,
sometime it takes long , please program to range high at least upto
rows 5000
If the macro is correct , I will expect the results as follows on cell c
227.000.74
227.000.75
227.000.76
227.000.77
227.000.78
227.000.79
227.000.80
227.000.81
227.000.82
227.000.83
Who ever returns the file answered please return file as attachment , thank you
Hello makinmomb,
The macro below has been added to the attached workbook. The results are returned in column "C". You can run the macro manually from the Macro Dialog (use ALT+F8 to display) or attach it to a button.
EDIT: System uploaded my previous file not the file for this poster. That's a new twist.
Please Login or Register to view this content.
Last edited by Leith Ross; 04-06-2014 at 02:11 PM.
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!)
You have attached the wrong file
yes it works , you saved me a hassle of doing it a longer way ,
this is zoom quick , thanks
Hello makinmomb,
I corrected the file error. You can download the correct file now. The system loaded my previously posted attachment, not the one I selected.
Okay thanks , I had picked your code and pasted
it since had a some work on it , yes it saved a ton
lot of time , I am smiles , thanks again
Hello makinmomb,
You're welcome. I'll mark this post as solved.
Oops I usually to that , ouch
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks