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.

Have never used Excel 2000 but in 2003 version you can EditFindFind Next to
go to first found cell.

Hit F2 and do your cell editing then ENTER without closing the Dialog box.

Find Next goes to next cell.


Gord Dibben MS Excel MVP

On Tue, 18 Dec 2007 13:20:05 -0800, Mr TJA <Mr
wrote:

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.

In xl2k, you have to dismiss that Edit|find dialog before you do anything to the
worksheet.

I don't recall if this changed in xl2002 or xl2003, though.



Gord Dibben wrote:

Have never used Excel 2000 but in 2003 version you can EditFindFind Next to
go to first found cell.

Hit F2 and do your cell editing then ENTER without closing the Dialog box.

Find Next goes to next cell.

Gord Dibben MS Excel MVP

On Tue, 18 Dec 2007 13:20:05 -0800, Mr TJA <Mr
wrote:

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.

--

Dave Peterson

Maybe you can use Jan Karel Pieterse's FlexFind:
http://www.oaltd.co.uk/MVP/



Mr TJA wrote:

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.

--

Dave Peterson

Definitley has been changed for 2003.

Re-read my post that you responded to, eh?


Gord

On Tue, 18 Dec 2007 17:38:50 -0600, Dave Peterson
wrote:

I don't recall if this changed in xl2002 or xl2003, though.

I still primarily use xl2003. I'm too lazy to start up a virtual pc to get to
xl2007. And I didn't keep xl2002 installed, so I can't check that.

Gord Dibben wrote:

Definitley has been changed for 2003.

Re-read my post that you responded to, eh?

Gord

On Tue, 18 Dec 2007 17:38:50 -0600, Dave Peterson
wrote:

I don't recall if this changed in xl2002 or xl2003, though.

--

Dave Peterson

Been a couple of years but I don't think 2002 was same as 2003.

You still had to dismiss the dialog before editing.


Gord

On Tue, 18 Dec 2007 18:46:35 -0600, Dave Peterson
wrote:

I still primarily use xl2003. I'm too lazy to start up a virtual pc to get to
xl2007. And I didn't keep xl2002 installed, so I can't check that.

Gord Dibben wrote:

Definitley has been changed for 2003.

Re-read my post that you responded to, eh?

Gord

On Tue, 18 Dec 2007 17:38:50 -0600, Dave Peterson
wrote:

I don't recall if this changed in xl2002 or xl2003, though.

Maybe someone using xl2002 will jump in with a confirmation???

Gord Dibben wrote:

Been a couple of years but I don't think 2002 was same as 2003.

You still had to dismiss the dialog before editing.

Gord

On Tue, 18 Dec 2007 18:46:35 -0600, Dave Peterson
wrote:

I still primarily use xl2003. I'm too lazy to start up a virtual pc to get to
xl2007. And I didn't keep xl2002 installed, so I can't check that.

Gord Dibben wrote:

Definitley has been changed for 2003.

Re-read my post that you responded to, eh?

Gord

On Tue, 18 Dec 2007 17:38:50 -0600, Dave Peterson
wrote:

I don't recall if this changed in xl2002 or xl2003, though.

--

Dave Peterson