Find by one cell, replace multiple cells in the same row

**ZachSEEI** · 10-27-2011, 04:52 PM

Hello,

I have a worksheet of about 6000 cells. I have cells that until after I had finished I did not know the contents of.
For example:

11 | MOM-9 | Force On | 40621 | Disabled | Enabled
22 | MOM-7 | Force On | 40626 ? | ?

There are many more rows like this. I would like to search through the entire document for any cells that say "Force On" and replace the two cells one over to the right with Disabled and Enabled, as demonstrated in the first row.

Is this possible?

Thanks in advance,
Zach

**mrice** · 10-27-2011, 04:55 PM

Suggest adding autofilters and filtering for Force On.

Then add the new values to one row and copy down using the fill handle - bottom right hand corner of the cell.

**ZachSEEI** · 10-28-2011, 09:15 AM

Originally Posted by mrice

Suggest adding autofilters and filtering for Force On.

Then add the new values to one row and copy down using the fill handle - bottom right hand corner of the cell.

Wow I didn't even think of that. I was looking for something more instant, like a replace all, but that will do just fine. Thank you for the assistance.