leezac

asked on

# Insert text into column

I need to do the following to insert text on one sheet based on a column not being null on another sheet. I need help with the VBA.

If sheet4 column AP is not null

Insert "1" into Sheet19 column D

where sheet4 columnC = Sheet 19 Column A ----- ' for the ID number to match

Thanks in advance.

If sheet4 column AP is not null

Insert "1" into Sheet19 column D

where sheet4 columnC = Sheet 19 Column A ----- ' for the ID number to match

Thanks in advance.

SOLUTION

membership

Create an account to see this answer

Signing up is free. No credit card required.

ASKER CERTIFIED SOLUTION

membership

Create an account to see this answer

Signing up is free. No credit card required.

ASKER

I am using 2003 now but will be converting to 2010 in the future.

The third formula will work on all versions.

The second formula will not work on 2003.

The second formula will not work on 2003.

Only one of the answers could be correct. Then why split points?

ASKER