Thaks Marvin,
I am aware of autofilter, but wish to get the information onto the other sheet using formulas.