Macro - changing value depending on the original value

Can you please kindly help me to avoid lots of slavish work?
I have a column where there are - among others - also cells with the following values:
$$$to be sent
$$$to be sent2
$$$to be sent3
$$$to be sent4
$$$to be sent5

The active cell is just in this column (the cell is selected). I want a macro which would change these values (nothing else) in THIS column into $$$sent, preserving the eventual number indexes (meaning "$$$to be sent" into "$$$sent", "$$$to be sent2" into "$$$sent2" ....... ). (The cells not containing any of the above values should be left intact).
Please ask me for more explanation if convenient.
Very many thanks in advance!
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!