Link to home
Create AccountLog in
Avatar of leezac
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.
SOLUTION
Avatar of jsdray
jsdray
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of leezac
leezac

ASKER

Thank you - I will test today the suggestions.
Avatar of leezac

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.
Only one of the answers could be correct. Then why split points?