I have a macro that opens another workbook(Stats) and pastes 4 columns of data into columns N, O, P, Q on Sheet1 which works great.
I am trying to write a worksheet change event in sheet1 that will copy only the rows that contain data in those 4 columns to the next blank row in sheet5
This code...