Filter and copy info from one sheet to another

I

ian-ok

Hi

I'm trying to copy rows of information from one worksheet to another dependin
on a criteria of a certain cell.

For e.g.
worksheet 1 has a rows of data from A2 to AM2 being one full set of data and s
on

In Column b2 i have the property address and want to filter all the fields wit
the same property address and make the list appear on worksheet 2 in the sam
format as worksheet1 i.e.a2 - am2

Is this possible?

Thanks Ian
 
Top