Gowflow, this question is an enhancement to you solutions to questions found here:
which was later amended with this solution:
Gowflow, what we need to do now is that when we import the email that the above solutions provided is:
1. Determine the ROE at the moment the row/record is created (imported from Outlook) to the Wire-Staging-FBME sheet then multiply the value in Col F by that ROE (Euros to USD) and insert the product in Col P.
2. And, multiply the value in Col M by the ROE (Euros to USD) and insert that product in Col Q.
After this is done, we can come back to the related question with summing the values in Col P and Col Q.