1.From the drop-down option, choose “Use Relative References.” 2. To begin, pick a single cell (for example, cell B8). 3. After that, select Record Macro. 4. In the search box, type the word “sales.” 5. After typing “production,” hit enter. 6. Enter Logistics in the search box. 7. Stop recording by clicking the Stop button. 8. Run the recorded macro in any other cell (for example, cell D4).