I need a macro for Excel to do the following.
Step 1: Look within a specified cell (i.e A1) and copy all the text in that cell (i.e it will find the text "dataSEARCH&REPLACE") which will be used as the text to search with in step 2.
Step 2: Search within cell C1 (C1 contains various text) which will contain in one instance the text "dataSEARCH&REPLACE". The macro is to replace the text "dataSEARCH&REPLACE" with all the text stored within cell B1
This is a simple idea, but unfortunately I have not been able to find the code already in the forums that can do this task?
I look forward to your suggested code.