Dear All,
please have a look at the attached file.
I want to sort the data by the comments in Column B, specifically by comments that do contain a telephone number, whether it is "Telefon" ( e.g. in B17 ) or "Phone" ( e.g. in B24 ) or "Téléphone" ( e.g. in B16 )
I know a Macro written in VB could do that.
Any help is much appreciated.
Thank you. Felix
Last edited by elgato74; 10-03-2009 at 04:59 PM.
It ould be much simpler to have the phone numbers in a hidden column & sort by that column
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thank you, but how would I transfer the Phone numbers in a hidden cell next to the cell containing the comment ? The original list has over 7000 rows ...
... possibly a Macro that extracts the Phone numbers to a cell next to the cell containing the comment ? But that would shift all other data to the right ?
Is there any way that a Macro would search the Comments in Column B and if it contains the word Telefon, Phone or Téléphone it sorts it to the top ?
Is there any way that a Macro would search all the Comments in Column B and if it finds the word Telefon, Phone or Téléphone it sorts that row to the top or at least marks it ?
Try this out:
This sorts first by whether there is a "phone" comment, and then by column D.
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
You are fantastic ! Superb !
Now, ideally i would want all the ones with Telefon to be sort first, then all the ones with Phone and then all the ones with Téléphone ...
Can this also be done ?
==========Please Login or Register to view this content.
If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].
(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)
Thank you Thank you Thank you !
You're the Best
Have a great day ...
Felix
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks