Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find & Replace Macro Issues---Please HELP.
First off let me say thanks to anyone that can help me out here. I am
sure my question will be easily answered. I have searched this group for over an over and haven't found a solution that works that well. What I am having problem with is a Find & Replace macro updating about a 1000 corresponding ID's and replacing those numbers with corresponding names. I have an Excel document where my data is in column J only that I want to change. I can't limit the find&replace macro to just that column (I just don't know code that well). I have a sheet called "data" that looks like Column A (ID) Column B (NAME) 25743 Monster House 12790 Cars 54689 Saving Private Ryan I then have the other sheet that has a column J matching the above column A data, but separated by a "/"...see below Column J 25743/12790/54689 What I want is to have the macro look in the "data" sheet and change the column J in my "inventory sheet" to look like Monster House/Cars/Saving Private Ryan I have a list of about a 1000 ID's in A and the names in B in the data sheet. Again, I only want to change the data in column J on the inventory sheet. Can you please help me? Thanks. Conor Finnegan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and replace macro | Excel Discussion (Misc queries) | |||
Find & Replace Macro | Excel Programming | |||
Using Find and Replace to replace " in a macro | Excel Programming | |||
Help with find and replace macro | Excel Programming | |||
Using Find & Replace in macro | Excel Programming |