Don't copy cell if certain text

[etaver87]

Hi everyone,

I have the following code:

Please Login or Register  to view this content.

It copies from cell J1 to C6.

Now I want to alter the code so that it doesn't copy the data from J1 to C6 if the J1 has the text "00.01.1900" in it. In all other cases it should still copy as usual. How can I do that?

In advance many thanks for your help!

[Faridwahidi]

From the record code, it seems that you have copied J1 and J2 but you want the condition only for J1, is it right?

If the code helped you, please add reputation to me "*"

Try this,

Please Login or Register  to view this content.

[etaver87]

Thanks for your help!

Actually, I would like for J1 and J2. So if there is the value 00.01.1900 in J1 and J2 it should leave the cells C6 and D6 blank.

Unfortunately, your code didn't help.

[Faridwahidi]

just add condition to J2

Please Login or Register  to view this content.

If the code helped you, please add reputation to me "*"

[etaver87]

It still copies over the values. Do you have any other ideas?

[Winon]

Hello etaver87,

Maybe:

Please Login or Register  to view this content.

Regards.

[etaver87]

Fantastic, it worked like Faridwahidi suggested but with Text instead of Value!

[Faridwahidi]

try change it to .text

Please Login or Register  to view this content.

[Winon]

Hi etaver87,

Glad I could assist solving your issue with a different approach.

Thank you for adding to my Reputation.

If that took care of your original question, and if you have managed to solve your issue please select Thread Tools from the menu link above and mark this thread as SOLVED.

Thanks.

Regards.