I have a workbook, and it consists of many worksheets. The main worksheet is called Raw Data. In here, is sometimes up to 80,000 rows of data, most of which will stay on this worksheet, but some rows need to be deleted, some need to be copied to another worksheet, and some need to be copied to another worksheet and then deleted from Raw Data.

In Column DL, I manually filter looking for CNC, these rows are just deleted. Again in Column DL I manually filter this time on Night, and these rows are copied to the worksheet called Night, and then they are deleted from Raw Data worksheet. Finally in column CK I manually filter, this time I exclude blanks (values will be numeric between 1 & 5, or be blank), These are copied onto the worksheet Feedback, but also remain on Raw Data.

I can do all this manually, but I'm trying to speed up the process, and researching the web has only made me more confused. I've tried recording the steps, but just can't seem to get it to work as intended with anything other than the test file

I'm using Excel 365, and ideally I would like the VBA to be stored in my personal macro workbook, rather than the file itself.

Any help will be gratefully received.