Where to put results of the "find" function.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DEP - 21 Nov 2006 22:01 GMT

in EXCEL 2002 during the very first use of "find" one is asked what to
do with the results of the find. Either to copy to another location in the
worksheet, or list at the bottom of the find window. The dialog box does
not open again on subsequent uses of "find". How does one get back to that
dialog box, or is there another way to change where the results of a "find"
are placed after the initial pass?

Reply to this Message

Don Guillett - 22 Nov 2006 13:14 GMT

To place the results you need a formula or a macro using FIND. Look in the
help index.

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> in EXCEL 2002 during the very first use of "find" one is asked what to
> do with the results of the find. Either to copy to another location in
[quoted text clipped - 5 lines]
> "find"
> are placed after the initial pass?

Reply to this Message

Gord Dibben - 22 Nov 2006 19:25 GMT

You won't get any different answers than the last bunch you received on Nov.
14th and 16th.

Gord Dibben MS Excel MVP

>in EXCEL 2002 during the very first use of "find" one is asked what to
>do with the results of the find. Either to copy to another location in the
>worksheet, or list at the bottom of the find window. The dialog box does
>not open again on subsequent uses of "find". How does one get back to that
>dialog box, or is there another way to change where the results of a "find"
>are placed after the initial pass?

Reply to this Message

Rate this thread: