I'm trying to write a macro that inserts a line of data from one part of the
sheet, to the bottom of a list. Is there a function for this?

There could potentially be over 1000 rows in the list, so I don't really
want to go down the 'IF' route!

Thanks