Hi Guys
I have a spreadsheet which I have attached basically the sheet Chartdata takes information and dates from the main sheet. I have created the formula which need to anaylase the dates to see if they are late on time or early. This then need to be total again whether they are a P or E feature.
I also need to work out if a date has been saved so if was Late now early this would equal to saving the timeline.
The sheet gets updated all the time so need a way to automatically analyse new information.
Need a macro to do all of which the Chartdata is doing and also look at the new sheets.
Hope someone can help.
I have a spreadsheet which I have attached basically the sheet Chartdata takes information and dates from the main sheet. I have created the formula which need to anaylase the dates to see if they are late on time or early. This then need to be total again whether they are a P or E feature.
I also need to work out if a date has been saved so if was Late now early this would equal to saving the timeline.
The sheet gets updated all the time so need a way to automatically analyse new information.
Need a macro to do all of which the Chartdata is doing and also look at the new sheets.
Hope someone can help.
