Hello All,
I was hoping someone could help me figure out how to find and replace a range of values. I've looked online, and searched the forum with no sucess.

I have a list of cells in a column labled "Check #1", "Check #2", "Check #3" ect. I'm trying to build a Macro that would help me replace any value from "Check #1" to "Check #50,000" with "Outgoing Check". I know this can be done manually with relative ease, but it will need to be done very very very often, so I'd like to automatic it as much as possible.

Any tips on how this can be done? Ideally I'd like to put the steps into a Macro or Formula that could be re-produced with ease.

Thanks in advance for your help.