I have an excel chart with a list of contracts with start dates and end dates. I have manually created a gannt chart showing the life of the contracts, but want to automate it so that all i have to do is change the end date of contracts and the gannt chart automatically updates. In addition, I need to be able to add and remove contracts as they complete and new ones are won. I also want the start date shown in the gannt chart to be the current calendar quarter and change automatically so that the gannt chart shown today will be different in six months if the data doesn't change. I have attached my manual spreadsheet.
I am an excel developer. I am expert in Excel both excel standard and Vba coding. I work with excel more than 10 years. I send you sample file, please check if this is what you want.
7 freelancers are bidding on average $40 for this job
Hello Sir, Excel VBA expert here, I have just completed a Dynamic Gantt chart project, plz check my profile to check it out, also chk PM for DEMO of that. Regards.