related to: Import specific emails from Outlook (2007) to an Excel spreadsheet (2007)
Gowflow, this question is an enhancement to you solutions to questions found here:
https://www.experts-exchange.com/questions/27156733/Import-specific-emails-from-Outlook-2007-to-an-Excel-spreadsheet-2007.html which was later amended with this solution:
https://www.experts-exchange.com/questions/27475716/related-to-Outlook-to-Spreadsheet-previous-question.html
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.
https://www.experts-exchange.com/questions/27156733/Import-specific-emails-from-Outlook-2007-to-an-Excel-spreadsheet-2007.html which was later amended with this solution:
https://www.experts-exchange.com/questions/27475716/related-to-Outlook-to-Spreadsheet-previous-question.html
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.
ASKER
Activated when we click on Import Emails button
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That worked! What exchange rate are you using? The same as for the WU-Staging-FBME sheet?
ASKER
Now we can go back to the previous question and total up Cols P and Q where the date in Col A = the previous month and put those sums in the cells and spreadsheet indicated in that question.
yes same rate as WU-staging-FBME actually it is the rate when you import you mean the site is the same.
gowflow
gowflow
Import Emails button ?
Import Emails into Tab button ?
Import WU Confirmed Amounts button ?
Import WU Emails button ?
gowflow