Completed

Excel Macro/VBA needed

This project was successfully completed by koolsidz for $280 USD in 2 days.

Get free quotes for a project like this
Employer working
Completed by:
Project Budget
$250 - $750 USD
Completed In
2 days
Total Bids
30
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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online