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

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

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

Hi Kezza,

what exactly do yo need?

Regards,
Ivan

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

Try using Find & Replace
Ctrl

--
mudrake
-----------------------------------------------------------------------
mudraker's Profile: http://www.excelforum.com/member.php...nfo&userid=247
View this thread: http://www.excelforum.com/showthread.php?threadid=54064

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

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

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

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

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

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.