View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mr TJA Mr TJA is offline
external usenet poster
 
Posts: 1
Default Navigate excel worksheet with find dialog box open

I am using Excel 2000 on Windows XP.
How can you set an option so you can navigate the worksheet while you have
the find dialog box open. It appears very fundamental that one would want to
look for an occurence of a value or string, then make an edit, then "find
next" the next occurence, repeat the edit, etc ...
This is not an example of a search and replace. I am looking up certain
values, which takes me to a certain area of a 12,000 line long worksheet.
Then I page iup or down withing this area up to 100 rows. to find another
value.
This is not an example of Vlookup either, as no patterns exist.

I need to be able to use find next and have access to the worksheet without
having to close the find box in between each edit.