VBA Excel macro to open file, manipulate data, send email

  • Posted:
  • Proposals: 10
  • Remote
  • #1810695
  • Awarded
Sathish S.
Les K.Dave G.Simon C.Catalin B. + 5 others have already sent a proposal.
  • 4

Description

Experience Level: Intermediate
General information for the business: Financial Services
Kind of development: New program from scratch
Num. of modules: 2
Description of requirements/functionality: Two similar processes:

Intraday

- Open last downloaded CSV with name containing specific words (in local downloads folder)
- Delete rows that do not contain certain words in a specific column
- Calculate all revenue (from revenue column) attributed to a certain user (in another column)
- Output an email with a table showing all revenue for each user for the day


End of Day

- Open last downloaded CSV with name containing specific words (in local downloads folder)
- Delete rows that do not contain certain words in a specific column
- Calculate all revenue (from revenue column) attributed to a certain user (in another column)
- Take revenue figure for each user and add it to a ‘running total’ spreadsheet for the month. Any new users would automatically be added to ‘running total’ spreadsheet.
- Output an email with a table showing all revenue for each user for the day, plus a running total for the month.
Specific technologies required: VBA Excel
OS requirements: Windows
Extra notes: I would like to get a quote. If acceptable, immediate start. Work to be completed ASAP.

New Proposal

Create an account now and send a proposal now to get this project.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.