How to automatically move/copy data from one sheet to another if certain criteria met

Hi,

I am creating a spreadsheet to map children's academic attainment for my school. The 1st sheet maps their attainment over time & I'm working through conditional formatting & data validation for those leading to percentages - which I am fine with. I'm looking to copy rows that fulfil certain criteria over to subsequent sheets. Eg copy entire row of data for every child that has special educational needs to a new sheet or copy entire row of data for boys/girls. Is their a straightforward way of doing this dynamically without filtering & copying/pasting (I have googled & many responses seem to be suggesting using Macros which seem far too complicated!)

Any help/ideas would be greatly appreciated! I'm struggling


Craig

Thanks for the kind welcome!

Apologies for the lack of detail! I am looking to copy a whole row of data from my main data sheet (Sheet 1) to another sheet Eg A24 to DB24 IF it fulfils certain criteria - like for example copy the row A24 to DB24 if the value in cell C24 is "SA" and for this to work for every row of data from 24 to 53. Or put another way all of the data for a certain entry that fulfils the "SA" criteria to be copied to another sheet. I want to repeat this for other values on other sheets but it will be pretty formulaic once I can get my head around this first one. Hope this is slightly clearer.


Thanks
Craig