Hey all, Im new at this and am not very good with VBA yet, so was hopping for a formula? I can do a VBA if its easier.

What I want to do is find any Cell in coloumn AC that contains the value "1",
Then copy certain cells from that row in sheet "Trafford MC" to "Sheet 2".

I am having no luck. please help.