In Progress

Program the reads excel file,sorts and emails users

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 [url removed, login to view] GMT

Any questions please let me know.

Thanks, CWPS

Skills: .NET, C Programming, Excel, Microsoft Access, Visual Basic

See more: programming in excel, excel c# programming, programming with excel, sales excel, i need a sales rep, f2, Excel file, visual basic excel project programming, read email gmail, reads, visual basic week, email excel file, screenshot excel, read excel file program, program sales, excel sales, excel file program, program chat program project, sales program excel, excel visual basic gmail, excel gmail, match programming, read excel visual, excel programming sales, programming chat

About the Employer:
( 20 reviews ) Dublin, Ireland

Project ID: #1545847

Awarded to:

dotnetsupercoder

Thanks for project.

$100 USD in 1 day
(30 Reviews)
6.0

2 freelancers are bidding on average $175 for this job

barundebnath

Hi, I am interested. But I am not seeing any attachment. Did you forget those ? Send me those files then we can discuss it further. Thanks

$250 USD in 5 days
(51 Reviews)
6.0