Copy cells with data - paste (insert rows) to next sheet.

Hi,

I have the following macro which will copy populated rows in sheet 'MLS' and paste them in the first empty row after A20 in 'SalesDB'.

However, rather than just paste the values, I'd like it to insert the rows at the first empty cell after A20.

Can anyone offer any advice what to modify in order to achieve this?

Please Login or Register  to view this content.

Many thanks

Thanks for the reply.

However that code gives me the error "This won't work because it would move cells in a table on your worksheet".