I have a large spreadsheet where all the data comes out in the one go. I want to do the following:-

Find CY and copy all the data (columns A-L) up to DL but not including DL and put it on a new sheet named CY
Find DL and copy all the data up to EU but not including EU and put it on a new sheet named CY
Find EU and copy remaing data into a new sheet named EU.

How would I do this? I am fairly new to macros so any help would be appreciated. I have attached a test copy of my data.

Attached Files

Test file.xlsx (430.7 KB, 11 views)