In Progress

Excel Macro/VBA needed

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: Excel, Powerpoint, Visual Basic for Apps, Word

See more: excel to powerpoint macro, excel powerpoint macro, excel macro to word, vba for word, excel 2013 vba, create macro in word, vba word, vba project f, vba excel macro, vba e, report from excel, project on vba, powerpoint 16, ms word j, ms powerpoint, Macro vba, macro excel, macro e, macro + excel, excel to vba, excel project 2/2, excel powerpoint word, excel or word , Excel Macro VBA, excel charts

About the Employer:
( 21 reviews ) Kiryat Ono, Israel

Project ID: #4339495