Hi,

I am new to the forum and am looking for help creating a macro. The macro needs to perform the following task.

Copy and Paste Special Values any cells in the range O4 and AC5000 in sheet named At Terminal that do not contain the text TBD. The cells are only being pasted over the top of the existing cells to remove a positive result from a formula (TBD is a text response as a false response, the underlying formula should remain as a true result may follow at a later time).

I have tried modifying existing macro's I was able to find but had no success.

Looking forward to any help!

Thank you,

Cassandra