Hi Guys, I'm back once more, hoping you can continue my salvation.

I've got raw data from a rostering program. I want to create a summary page of all employee's overtime hours and the shift date, commence time and end time.

Overtime hours are in column O. If cell empty, skip to next cell. If cell has data (any data, doesn't matter what), then move to column D on same row and paste data to dashboard!D5, then move to column G, paste data to dashboard!E5, then loop onwards to the next cell in column O with data.

It would probably be best if a 'insert row' was used just prior to the pasting of data on the dashbaord, as the spreadsheet will be run monthly, and the dashboard will accumulate new data each time, which, without an insert row feature, will eventually overun previous rows.

sample workbook attached

Sample workbook.xlsm

you guys are unbelievably awesome

Thanks in advance!