I would like to create a macro that does the following. Due to the fact that I can’t record these types of steps, I was wondering if I could get some help.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Every time a cell in Column D contains NEW1 or OLD1, I would like “Customer” to be entered into Column G in the same row.
<o> </o>
Every time a cell in Column D contains OLD2, I would like “Assets” to be entered into Column G in the same row.
<o> </o>
Every time a cell in Column D contains NEW2, I would like Column G in the same row to contain “ShortTerm”
<o> </o>
Every time a cell in Column D contains OLD3, I would like Column G in the same row to contain “LongTerm”
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Every time a cell in Column D contains NEW1 or OLD1, I would like “Customer” to be entered into Column G in the same row.
<o> </o>
Every time a cell in Column D contains OLD2, I would like “Assets” to be entered into Column G in the same row.
<o> </o>
Every time a cell in Column D contains NEW2, I would like Column G in the same row to contain “ShortTerm”
<o> </o>
Every time a cell in Column D contains OLD3, I would like Column G in the same row to contain “LongTerm”