Would like to change all "yes" cells in a worksheet with "logged"

Hi all, can anyone help me to achieve this.Thanks

Try using Find & Replace
Ctrl H

Hi Kezza,

what exactly do yo need?

Regards,
Ivan

select an area that contains all the cells you want to replace and do

Edit=>Replace

Type in Yes in the first box and Logged in the second box.

Then click replace all.

--
Regards,
Tom Ogilvy


"Kezza" wrote:

> Hi all, can anyone help me to achieve this.Thanks
>
>

Select all cells (click on upper left corner)
Edit/Replace: enter "yes" and "logged" in the appropriate fields
Click Replace all!

Regards,
Stefi

„Kezza” ezt �*rta:

> Hi all, can anyone help me to achieve this.Thanks
>
>

I have a lot of "Yes" cells in a worksheet which prompts me that data
needs to be transferred to another worksheet at the end of the day. I
would like something basic that would change all the YES cells to
LOGGED so that I don't transfer the same data again the next day. I
hope this makes sense. Hopefully I will the assign the macro to a
CommandButton.