<div>
Thank you - I will test today the suggestions.
</div>


Thank you - I will test today the suggestions.

<div>
I am using 2003 now but will be converting to 2010 in the future.
</div>


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

<div>
The third formula will work on all versions.<br />
<br />
The second formula will not work on 2003.
</div>


The third formula will work on all versions.

The second formula will not work on 2003.

<div>
Only one of the answers could be correct. Then why split points?
</div>


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

<div>
<div class="content wysiwyg-content">
I need to do the following to insert text on one sheet based on a column not being null on another sheet. &nbsp;I need help with the VBA.<br />
<br />
If sheet4 column AP is not null <br />
Insert &quot;1&quot; &nbsp;into Sheet19 column D<br />
where sheet4 columnC = Sheet 19 Column A &nbsp; ----- &nbsp; &nbsp; &nbsp; &nbsp;' for the ID number to match<br />
<br />
Thanks in advance.
</div>
</div>


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.

Insert text into column

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.