Macro to Search/Replace Text from another Column
Solved/Closed
mylove0mylife
Posts
3
Registration date
Monday July 15, 2013
Status
Member
Last seen
July 18, 2013
-
Jul 15, 2013 at 05:01 PM
mylove0mylife Posts 3 Registration date Monday July 15, 2013 Status Member Last seen July 18, 2013 - Jul 18, 2013 at 02:53 PM
mylove0mylife Posts 3 Registration date Monday July 15, 2013 Status Member Last seen July 18, 2013 - Jul 18, 2013 at 02:53 PM
Related:
- Macro to Search/Replace Text from another Column
- Www.google.com search video - Download - Video playback
- How to search a youtube channel - Guide
- Yahoo search history - Guide
- Vim search text - Guide
- Spell number in excel without macro - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
Jul 18, 2013 at 11:21 AM
Jul 18, 2013 at 11:21 AM
Hi Mylove0mylife,
Before turning to macro's we could solve this using VLOOKUP.
Insert an extra column called something like "Corrected Clinician Rpt Name".
Use VLOOKUP in this column. (Make sure you sort the sheet with the names on column A).
Now you could hide the original "Clinician Rpt Name" column.
You can filter your data to remove the rows with empty cells where a name should be.
Best regards,
Trowa
Before turning to macro's we could solve this using VLOOKUP.
Insert an extra column called something like "Corrected Clinician Rpt Name".
Use VLOOKUP in this column. (Make sure you sort the sheet with the names on column A).
Now you could hide the original "Clinician Rpt Name" column.
You can filter your data to remove the rows with empty cells where a name should be.
Best regards,
Trowa
mylove0mylife
Posts
3
Registration date
Monday July 15, 2013
Status
Member
Last seen
July 18, 2013
Jul 18, 2013 at 02:53 PM
Jul 18, 2013 at 02:53 PM
Oh my goodness! Thank you TrowaD! That worked perfectly :) I've never used VLOOKUP before.
Thank you again! :)
Thank you again! :)