Macro Loop and Paste in next empty row

Cheers mate.

I replaced the 'find last' with a crude method of selecting a cell 34 rows down using

maxapps = maxapps +34

34 because the number of rows selected from sheet2 were 33. However in the cut down demo spreadsheet I've only included a handful.

My end loop statment doesnt work either :0( I have to 'escape' out of the macro.

odc stands for 'original data cell', so in theory incrementing it by 1 would push the cell range down a row?

Thanks again for your help.