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
26 freelancers are bidding on average $165 for this job
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.