I need excel file automation

  • Posted:
  • Proposals: 8
  • Remote
  • #666828
  • Awarded
David S.
K John S.Roy T.David H.Ashley H. + 3 others have already sent a proposal.
  • 2

Description

Experience Level: Intermediate
General information for the business: we need some excel automation!
Kind of development: Customization of existing program
Description of every module: We are looking for a excel file that will be a template for exporting a versioned .txt file.
We have a list of items that are selected by placing a “x” in a specific column. Based on that “x” the excel file, will have an action button to export a .txt file to a predefined location, in a predefined format, stripping some of the information from the excel table. A second tab will house a second list of notes that will be merged with the .txt file. We will also need the excel file to create a “versioned” .txt file in a separate folder with time stamp. Lastly it is necessary that when the .txt file is created a email with a “variance report” attached is generated and sent to a specified party.
Description of requirements/functionality: We are looking for a excel file that will be a template for exporting a versioned .txt file.
We have a list of items that are selected by placing a “x” in a specific column. Based on that “x” the excel file, will have an action button to export a .txt file to a predefined location, in a predefined format, stripping some of the information from the excel table. A second tab will house a second list of notes that will be merged with the .txt file. We will also need the excel file to create a “versioned” .txt file in a separate folder with time stamp. Lastly it is necessary that when the .txt file is created a email with a “variance report” attached is generated and sent to a specified party.
Specific technologies required: Excel
OS requirements: Windows
Extra notes:

New Proposal

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

Sign up

Clarification Board Ask a Question

    There are no clarification messages.