I have a spreadsheet that goes to column P. All cells have data except for
Column M. Half of column M contains data and the rest are empty cells. I
need to copy or move all data rows associated with the cells in column M
that contains data. Normally I would be able to do this by just recording
macros, but data is constantly being added.

Hope I explained this correctly. Any advice is greatly appreciated.
Thanks.