How to add a text in a cell below a searched cell?

[caesar62]

Hello, I wonder if it is possible to create a macro that would insert e.g. a character "Z" in a cell below every instance of a cell with a character "X"?

Let's say I have a column C and within this column cells with a letter X appear from time to time. I want a macro to search Xs and insert Zs below every cell with Xs.
I have:
X


X




X

I want:

X
Z

X
Z



X
Z

If a second macro could be created but with inserting Ys above each cell with X my satisfaction would be immense.

[Solus Rankin]

Please Login or Register  to view this content.

[Solus Rankin]

Caesar,

If you are happy with that solution, please mark the thread as [SOLVED]. If you have other questions please start a separate thread for them with an appropriate title, so that other users can find it easily.

I'm sure there are plenty of people that would like to help.

[caesar62]

Solus, thank you, but in the bottom of my first post I asked for a similar macro with inserting Ys above each instance of X. If I get the second macro I will mark the thread as "SOLVED" if first you instruct me how to do that :-) I'm sorry, but I'm quite new here. I hope you got my reputation.

[caesar62]

OK, I've found it. "Thread tools".

[JOHN H. DAVIS]

FWIW:

Please Login or Register  to view this content.

[Solus Rankin]

Look like John has an option.

Or:

Please Login or Register  to view this content.

[caesar62]

Thnx John but it doesn't work. Your macro is to add both Y above and Z below. That's fine. There are circumstances that I need such a situation but also I need macro that would add e.g. Y only above X.

[Solus Rankin]

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[caesar62]

Solus, your code works fine :-) So now I need a macro that only adds Ys above Xs and not Zs below :-)

[Solus Rankin]

I see what you're saying now. See post #9.

[JOHN H. DAVIS]

OK.

Y

Please Login or Register  to view this content.

Z

Please Login or Register  to view this content.

Both

Please Login or Register  to view this content.

[caesar62]

Solus, I'm fully satisfied. You were very helpful. Now, I can close the thread. John, I also thank you for your involvement. Thanks to you both.

[caesar62]

John, I'm very sorry. You last codes are perfect - I thought it was Solus who posted them. You both were very helpful and professional :-)