Hi, I have been wrangling with this problem for a week so any help / pointers from someone with better excel knowledge than me would be greatly appreciated. I am trying to consolidate changing data from multiple worksheets, into a consolidation sheet for upload into a costing system. I need to miss out blank days (this bit is so far sorted I believe), blank hours etc but get the correct job codes / hours and so on against the correct days and employee. I have attached a workbook to help with this rambling explanation and any help would be fab.Example.xls