Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find replace function with a database
Hello All, What a great group and wonderful resource. I have searched for what am looking for but cannot. I am trying to do the following: My first excel sheet has the following. Column a has many names. Some names vary slightly. fedex 39393 fedex 393939090 fedex 2skd94 lowes qvc kinkos exxon exxon ie9d3k3 home depot 2334342 hope depot 222222 column B currently contains only one name or category for all the name in column A. EX expenses expenses expenses I would like to create some sort of database or 2nd excel sheet wit that would contain my reference information: NAME CATEGORY Fedex Shipping exxon gas Home Depot Supplies Then I want a macro to search my first excel sheet. When it find (fedex) in column a it then replaces the old category (expenses) wit the correct category from my reference data base to (shipping). I would need to automatically do this for every name/category in m reference sheet until it reached the end. Since the names var slightly it would also need to be able to catch the variations. I a not sure if this can be done all together or in a two step process. Meaning the first step conditions the name list with a find replace (find *fedex* replace fedex) so that there is no variations in th name. The second step would then replace the category names with th proper name. Or if this can be done all in one step or macro. Thank for eveyones help and I hope I was somewhat clear. k -- kausewa ----------------------------------------------------------------------- kauseway's Profile: http://www.excelforum.com/member.php...fo&userid=1512 View this thread: http://www.excelforum.com/showthread.php?threadid=26761 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replace the Find Function with a formula | Excel Worksheet Functions | |||
Multiple Find and Replace in one function | Excel Worksheet Functions | |||
HOW CAN I GET THE REPLACE FUNCTION TO DEFAULT TO FIND WHAT? | Excel Discussion (Misc queries) | |||
find replace function with a database | Excel Programming | |||
Find and Replace function for VBA? | Excel Programming |