on the data tab I have four columns of data being:
Name (cell B3 and down)
Type (cell C3 and down)
Start Date (cell D3 and down)
End Date (cell E3 and down)
Data is entered in a date range format or single day format.
I need the entered data on the data sheet to write the results to the output sheet everytime its updated so I presume a change event and break the date range down at a daily level. Please see spreadsheet attached for example.
thanks heaps guys