Excel Macro/VBA needed

IN PROGRESS
Bids
30
Avg Bid (USD)
$421
Project Budget (USD)
$250 - $750

Project Description:
The requested project is – create an Excel macro/VBA that will:
1. Automatically create charts from excel data
2. Automatically copy the created charts to MS Powerpoint and/or Word.

The Excel Macro/VBA should be relative to support different amounts and types of data.

This project is based on 2 Excel files - the "project" macro excel file for managing the project declarations and "Data1" Excel file that includes "raw data" for creating Excel charts (each sheet for each chart):
1. "Project" - Excel Macro file – this file is for managing the project declarations:
a. Data File - the name of the Excel file with the raw data for the charts
b. Output File - pptx (optional field) - if this field is not empty, then the charts made in the Data file are copied to the specified Powerpoint file. If this field is empty then nothing has to be copied.
c. Output File - docx (optional field) - if this field is not empty, then the charts made in the Data file are copied to the specified Word file. If this field is empty then nothing has to be copied.
d. Color1...Color15 (optional fields) - This are the colors (in R,G,B) that are used in the charts created. If these fields are empty then default Excel colors are used for the charts.
e. Chart headline (optional TEXT field) - if this field is not empty then these should be the headlines for the charts crated.
f. Sheet - This are the Excel sheets in the data file in which the chart raw data is stored.
g. Chart Type - This is the chart type used for creating each chart
h. Number [n] (optional TEXT field) - if this field is not empty then this text should be copied with the created chart to the Powerpoint and/or Word file
i. Dates (optional TEXT field) - if this field is not empty then this text should be copied with the created chart to the Powerpoint and/or Word file
j. Remarks (optional TEXT field) - if this field is not empty then this text should be copied with the created chart to the Powerpoint and/or Word file

2. "Data1" Excel file:
a. Sheet1 – Name of the report
b. Sheet2…Sheet[n] –Raw data for the Charts

Skills required:
Excel, Powerpoint, Visual Basic for Apps, Word
Additional Files: project.xlsx Data1.xlsx
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 1500
in 10 days
$ 280
in 2 days
Hire mrbrave
$ 300
in 5 days
Hire Premshanks
$ 499
in 5 days
$ 750
in 1 days
Hire chriskerpini
$ 620
in 7 days
$ 350
in 7 days
$ 250
in 3 days
$ 445
in 7 days
Hire pesek
$ 300
in 2 days