Program the reads excel file, sorts and emails users
$30-250 USD
Completed
Posted about 12 years ago
$30-250 USD
Paid on delivery
Hello,
I need a program that emails an excel file with figures from an excel file
The program will allow me to input the sales rep number, email address, Week1 %, Week2 %, Week3 %, Week4 % (See Screenshot demos attached)
User selects the excel file - (See excel file attached)
The program will read the attached excel file, calculate the "Where I should be" column which is "Current Mth EUR TRG." divided by the number of days in the month multiplied by the week2 % (Because we are in week 2) e.g. F2/21*10.8
Then the program emails the "Sales Rep" the lines of the excel file that match their "Sales Rep Number" that is setup in the program. (See Email example attached)
Serious bids only please. More work guaranteed if project is successful - I will be available on Email and Gmail chat 9am to 5.30pm GMT
Any questions please let me know.
Thanks, CWPS