I’ve been working on a Macro for quite sometime now that will automatically format a daily excel report and cannot seem to get the code right with this final part.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I'd like to create a Macro that will insert various text in Column U depending on conditions from column’s I and O within their corresponding rows.<o></o>
<o></o>
Ex.
If column I has the text “AM” & # in Column O <0, Column U should say “Accrual”
If column I has text “AM” & # in Column O (#'s) >0, Column U should say “Chargeback”
If column I has text “A” & # in Column O(#'s) is < 0, Column U should say “Bonus”<o></o>
If column I has text “A” & # in Column O(#'s) is >0, Column U should say “Chargeback”
If column I has text “BC” & # in Column O(#'s) is < 0, Column U should say “Agent”<o></o>
If column I has text “BC” & # in Column O(#'s) is >0, Column U should say “Wire”<o></o>
<o></o>
In total there are 13 different variables which has prevented me from using a nested if and looping
<o></o>
Also because the report changes from day to day I have no way of knowing how many lines there will be so the macro should fill in as long as there is data in columns I and O
<o></o>
Any help would be greatly appreciated.<o></o>
Thanks
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I'd like to create a Macro that will insert various text in Column U depending on conditions from column’s I and O within their corresponding rows.<o></o>
<o></o>
Ex.
If column I has the text “AM” & # in Column O <0, Column U should say “Accrual”
If column I has text “AM” & # in Column O (#'s) >0, Column U should say “Chargeback”
If column I has text “A” & # in Column O(#'s) is < 0, Column U should say “Bonus”<o></o>
If column I has text “A” & # in Column O(#'s) is >0, Column U should say “Chargeback”
If column I has text “BC” & # in Column O(#'s) is < 0, Column U should say “Agent”<o></o>
If column I has text “BC” & # in Column O(#'s) is >0, Column U should say “Wire”<o></o>
<o></o>
In total there are 13 different variables which has prevented me from using a nested if and looping
<o></o>
Also because the report changes from day to day I have no way of knowing how many lines there will be so the macro should fill in as long as there is data in columns I and O
<o></o>
Any help would be greatly appreciated.<o></o>
Thanks