Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find & Replace Macro from external spreadsheet/db?
Hello.
I currently have a Macro which replaces numbers in all cells in column A from row 3 onwards with different numbers. I would like to change the Macro so that instead of having all the replacements within the macro itself, it instead takes them from another Spreadsheet called numberchanges.xls on drive C. It would be a lot easier for me to maintain and update this way. I need a little help with making this Macro though as I'm not an expert with this sort of stuff. Below shows three lines of the present Macro and the replacements it makes: Columns(1).Replace What:="1143", Replacement:="7945", LookAt:=xlWhole, _ SearchOrder:=xlByRows, MatchCase:=False Columns(1).Replace What:="6762", Replacement:="4760", LookAt:=xlWhole, _ SearchOrder:=xlByRows, MatchCase:=False Columns(1).Replace What:="70775", Replacement:="90001", LookAt:=xlWhole, _ SearchOrder:=xlByRows, MatchCase:=False In the numberchanges.xls file I have this information in columns A and B from row 3 onwards. So 1143 is in cell A3 and it's replacement 7945 is in cell B3 and so on until the last value. How would I go about making the macro so that it opens the numberchanges file and makes the replacements in the current document? Would it be easier if I made an Access database file for it to find and replace the data from? Or would you be able to do it via some sort of query? Cheers for any help John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find/Replace External Data Web Query | Excel Worksheet Functions | |||
Find/Replace - Full Navigation of Spreadsheet | Excel Discussion (Misc queries) | |||
find&replace macro | Excel Worksheet Functions | |||
How do I find and replace a symbol in an excel spreadsheet | Excel Discussion (Misc queries) | |||
find and replace macro need help | Excel Programming |