In my Sheet 1 in column 'N' I have hundreds of refs. In a hidden sheet called Static I have a Table [see example below]
So, for all items in the table below where Col A is CA02 I need to copy any row with CAEU, CALS, CAOT etc etc from Sheet 1 to sheet10
I will then need to loop this so that I can do the same for CA02 then CA03 etc etc Each time copying to a different sheet. i.e. Sheet 11, Sheet 12 etc
I presume that once there is a loop I will just change the the code to reflect the changes?
Hope this is do-able and that I have explained myself ok