Copy a variable from one cell in a workbook if it is X then paste the value yes/no in another workbook cell

[drop05]

Is there VBA where you can copy a value from a cell in one worksheet in a workbook and if that value is = to "X" In that cell then it paste the value "YES"/"NO" in a cell in another workbooks worksheet?

 

[Fluff]

Duplicate to: Copy a value x from one workbook and paste it as yes/no if it is x in another workbook

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.