<div>
i'd use if formula here , just much more natural to excel , just type &quot;=if&quot; in &nbsp;&quot;AD&quot; &amp;&nbsp;&quot;AE&quot; &nbsp;and follow the instructions
</div>


i'd use if formula here , just much more natural to excel , just type "=if" in  "AD" & "AE"  and follow the instructions

<div>
What does this mean?
<blockquote>
<br />
The Previous Business Date has to be column AJ 
</blockquote>
</div>


What does this mean?

> The Previous Business Date has to be column AJ

<div>
The Previous Business Date would be populated to the same row as where there's values in Column BA, eg. today it would populate &quot;06/11/2013&quot;. I don't want a formula as this is a column where many commentaries must be written.
</div>


The Previous Business Date would be populated to the same row as where there's values in Column BA, eg. today it would populate "06/11/2013". I don't want a formula as this is a column where many commentaries must be written.

<div>
Do you mean as well as putting values in AD and AE you want the previous business day in AJ?
</div>


Do you mean as well as putting values in AD and AE you want the previous business day in AJ?

<div>
<div class="content wysiwyg-content">
Hi Guys, I want to do a Loop down Column &quot;BA&quot; of my spreadsheet and if a Cell has Value in it to populate the same Cells in Columns &quot;AD&quot; &amp;&nbsp;&quot;AE&quot; with the following comments &quot;Non Validated &nbsp;trade&quot; and &quot;Dashboard&quot;. The Previous Business Date has to be column AJ .How do I write the code for this?
</div>
</div>


Hi Guys, I want to do a Loop down Column "BA" of my spreadsheet and if a Cell has Value in it to populate the same Cells in Columns "AD" & "AE" with the following comments "Non Validated  trade" and "Dashboard". The Previous Business Date has to be column AJ .How do I write the code for this?

Loop question

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