stephen.smith
Board Regular
- Joined
- Jul 7, 2010
- Messages
- 119
Hey Guys
I am trying to perform a find and replace on a number of columns. I highlight the cells and type in the info I want to find and replace and then click replace all. The info in the cells that i being replaced is coming from a different workbook and excel asks me to update values and a window pops up asking me to find the workbook. I find the workbook and it updates only one cell, so if I want to change 100 cells I have to find the exact path again and again in this window. Is there an easier way to do this or a way to change a setting that once I find the link once it does it automatically for all other cells. It used to work automatically for me but not anymore.
Thanks
I am trying to perform a find and replace on a number of columns. I highlight the cells and type in the info I want to find and replace and then click replace all. The info in the cells that i being replaced is coming from a different workbook and excel asks me to update values and a window pops up asking me to find the workbook. I find the workbook and it updates only one cell, so if I want to change 100 cells I have to find the exact path again and again in this window. Is there an easier way to do this or a way to change a setting that once I find the link once it does it automatically for all other cells. It used to work automatically for me but not anymore.
Thanks
