Dear all expects
I’m very annoying that the too many address to find same address to sort and printout to an employees’
But the address are different format how can I asked help it if VBA / MACROS can help ?
What I looking for help :
COL D ( Address format like that )
Row 1 6F EVERGAIN BLDG. 21-23 RMA CENTER-QRA LAB
Row 2 HK TEST CENTER 6F,EVER GAIN BLDG
Can vba do if part of 60% are same than Row 2 = Row 1 . value ?
Just thinking it & highly appreciate your help.
VBA can do a lot of things - but if those two rows you've shown are equivalent, then it can't do that. Can you post a better example and, preferably, a sample spreadsheet - desensitized of course
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks