Macro to select non-contiguous union of cells based on values in other column

Dear Ladies and Gents,

I would very much appreciate your advice on a VBA problem I am trying to solve:

Data Given:
_____________________________________________
Column A | Column B

64______|_____Y_____
25______|_____N_____
54______|_____Y_____
15______|_____N_____
54______|_____N_____
34______|_____Y_____
_____________________________________________

Now, data in column A is derived by formula, for this problem does not matter by which one.

I would like to create a macro that would select cells (as a non-contiguous union) in column A, but only those, where for corresponding rows in Column B you have 'Y'.

Idea is that the second part of the macro would copy those selected cells and paste them as values, so that they are no longer formulas, but values instead. This way every line in A, that has 'N' or nothing in column B would still remain as a formula.

Many thanks in advance.
Michael

Hi sktneer,

Thanks for your reply, but does not seem to be working yet..

Regards,
Michael

Many Thanks Sktneer!

It was my lack of knowledge that prevented formula from working properly.

Kind Regards,
Michael