Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find & Replace Macro
Here is my data:
Col 1 Col 2 STDNUMBER IDSTUDENT 27050 1782 27004 1784 27063 1786 27006 1788 Basically what I need to do is look in the entire spreadsheet for (in example 1) 1782 and replace it with 27050, and continue down the list automatically to example 2, find 1784 and replace with 27004 and so on until it runs out of data in these 2 columns. Can anyone help???? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro: Find and replace | Excel Discussion (Misc queries) | |||
Find and Replace Macro | Excel Programming | |||
Using Find and Replace to replace " in a macro | Excel Programming | |||
find replace macro | Excel Programming | |||
find and replace macro need help | Excel Programming |