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 [url removed, login to view] GMT
Any questions please let me know.