Good day everyone...
I have the following requirement and i hope everyone will read the description and requirements carefully and then bid. I dont want keep on explaining from scratch once i award the project to a freelancer, specially that there is no time, this should be delivered by tonight or tomorrow at MAX.
Requirements:
I have the attached Excel file... there is two sheets {Planning and Chart}, the chart sheet have a list of object(A,B,C..etc) names with the whole 2013 calendar next to each object
The planning sheet, will be like a source of input to draw the chart, it will have data about these objects, you will find for example Object A with Date1, Date2 and Date3 values...
The idea is that we need to read the data in planning sheet and check if it has a record in the chart sheet and then start filling the cells within the dates given to create the gantt chart
Notes:
1- the list of objects in the chart sheet is not fixed! some times it will be like A,B,C,D only and some times will be more!
2- when we run to generate the chart, all previous chart should be cleared and start over as new one.
3- when reading from the planning sheet, if there are more than record for the same object {as in the sample file attached}, then chart should be filled on the same record for that object... (this means, in chart sheet we will have a list with distinct values of object names with many duration filled, but in the planning sheet we will have list with duplicate objects )
4- each object in Plaiing sheet have 3 dates values (date1,date2 and date3)... when we fill these dates in the chart sheet... we need to fill the period from date1 to date2 with color BLUE and the period from date2 to date3 with color RED
Hope the whole idea is clear now... Good luck
* Please remember, this is to be delivered either today late night or tomorrow by midday! bidder with 3 days+ delivery.. thank you,
Hello,
I'm experienced analyst with a lot of Excel automation and macro creation. Working with large data sets is no problem for me. You can check my ratings here and see that I have successfully done even more complex Excel tasks.
I can do this task for you within your time specification, but I'll need some clarification, just to be sure.
Please check PM for more detail