Is it possible to subtotal based on date (column C, but segregate based on currencies (Column G).
Also, if you look at the data in column A (Account numbers), the 'E' means Canadian and 'F' means USD. What if there were two letters per currency, how would the macro change. For example, two account numbers 'E' and 'A' meant Canadian and 'F' and 'B' meant USD?
Edit: Also notice they have the same date
Before Macro:
After Macro:
Also, if you look at the data in column A (Account numbers), the 'E' means Canadian and 'F' means USD. What if there were two letters per currency, how would the macro change. For example, two account numbers 'E' and 'A' meant Canadian and 'F' and 'B' meant USD?
Edit: Also notice they have the same date
Before Macro:
After Macro:
Last edited:
