I am attempting to create an Overall Equipment Effectiveness (OEE) spreadsheet for my work. I have developed a spreadsheet with the necessary input columns and made it a list. I now want to be able to have the list auto-expand when all the data in a row is filled in. However, whenever I protect the worksheet the rows do not auto-expand.

I know this is vague - so I have attached the spreadsheet for more clarity. From my very basic understanding of excel and the research I have done I need some VBA code. I have no clue how to program.

Any help is very much appreciated.OEE Calc_TEMPLATE.xlsx