Hey guys

I need VBA code that takes the highest row in a spreadsheet and copys it to the next empty row (on the bottom). Than I want all the rows to shift up by one.

Thank you in advance