Forum Discussion
find and replace
Using the find and replace function but a window pops up for EVERY replacement where I have to select the new file. help!
Hi Bcurtis1, When you say select the new file what do you mean? Can you do Replace all?
I'm selecting ctrl+h, entering my data and hitting enter. The find data is from another computer so it's (simplified) E\file\usethis lets say and I'm replacing to a file located on my desktop (WeekMay2). When I hit replace all, I get a dialogue box that says Update Values WeekMay2.xls, it's opening a folder I have on my desktop w/ the WeekMay2 file in it - I then have to select the open the WeekMay2 file for every replace I need to do. There's around 28k of them, so doing this by hand isn't an option.
I've managed to work around this by only replacing the first cells across my row and then copying down, but I have to do this in multiple places and would prefer to find/replace across the entire worksheet.
