Hello,



I'd like some help writing a macro/ script. I want to search for a value ("XYZ-123", case sensitive), then paste another value ("a12345", also case sensitive) in the cell 15 columns to the right of the first value. Then continue that for the entire sheet (a "replace all" sort of function).

Thoughts?

IR

Good afternoon, IRoll. This sounds pretty easy. Do you want someone to write it and you just use it, or would you like to know enough to do it for yourself? If the former, someone like Paul or Peco may (probably will) help you; if the latter, I get a lot more interested. Also, how much do you already know about writing a macro? As I said, this one looks pretty simple; you may not have to learn very much.

On the other hand maybe you're the sort who likes to learn. I'm not trying to discourage you, if you are.