Completed

Excel Macro, Dashboard, Calculations and Graphs

This project is to create macros , calculations and graphs

Sheet 1 should calculate certain fields and this result of this should be performed and outlined in The totals sheet and Graphs sheet. This should be able to be copied for different systems. Sheet 2 – is just a different version of sheet 1 but I would like to show this In graphs if someone has completed there task Yes Or No and who is holding this us. Highlight the cell in Red by defuat Sheet 3 - When I run the Marco I need to show the values form the sheets and different systems. Sheet 4 should displays graphs for all systems, How many documents drafted, How many documents have been reviewed, How many documents approved, Late tasks etc. All the table in attachment 1 should be visible in the graphs. Attachment 2 is an example of how I want this done. However, I would Like to use attachment 1. This should be all done by using marco buttons Again I would like to repeat this for multiple systems, therefore, if I copy sheets etc this should work automatically. This is the main requirement Attachment 01 has red cells to show you the information I would like.

Also I would like this to look good and have a nice dashboard

Skills: Excel VBA, Excel Macros, Data Processing

See more: excel macro create directory mkdir, excel macro create permutations, excel macro project daten importieren, excel macro protect project, automate excel macro graphs, cells empty dont create file excel macro, excel macro create txt file, excel macro create shape, excel macro read microsoft project, excel macro create unique file worksheet worksheet name, excel macro import project files, create xml file using excel macro, excel macro create xsd, create dynamic name excel macro, excel macro to create graphs automatically, would you add buffer to a project plan argue why you said yes or no, how do i insert a yes or no box in excel?

About the Employer:
( 9 reviews ) Newcastle Upon Tyne, United Kingdom

Project ID: #31604302

Awarded to:

(165 Reviews)
6.5

26 freelancers are bidding on average $165 for this job

(290 Reviews)
8.0
P0L

(281 Reviews)
7.6
(230 Reviews)
7.3
(112 Reviews)
7.0
(60 Reviews)
7.1
SShtv

Hello, I am interested in your project. Your task is clear to me and I am ready to solve it. I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA.

$250 USD in 5 days
(77 Reviews)
6.1
(101 Reviews)
5.8
(66 Reviews)
5.5
(13 Reviews)
5.8
raoarslan56

Here sir... I have read your job description carefully! Its gona be a fun to create a reporting spreadsheet as per your requirement... I would like to create MACROS, Interactive dashboard , reporting tab with formattin More

$110 USD in 1 day
(12 Reviews)
4.6
mzdesmag

Hi, I’m an experienced analyst information researcher, and science scholastic author. I have complete some Ph.D. level postulation activities, including progressed factual examination of information. Scanning for remar More

$100 USD in 3 days
(5 Reviews)
4.1
(6 Reviews)
4.1
(18 Reviews)
4.2
(22 Reviews)
3.9
(12 Reviews)
3.7
azraazeen9

Hello, i am ready exited to work you as i read your job description Excel Macro, Dashboard, Calculations and Graphs for products and companies. Kindly check My Portfolio as well. Hope for your very soon reply. Best Reg More

$100 USD in 2 days
(1 Review)
3.3
(5 Reviews)
2.6
(2 Reviews)
1.4
jamesdobbs11

Hi Dear! I already check your description with carefully and very interesting your project. Also I have a development experience of project like your project. Specially I have more than 10 years of experience in softwa More

$100 USD in 2 days
(2 Reviews)
0.4
(1 Review)
0.4