Hello, I have several sheets in a workbook with husband & wife
In the first example how would i extract all of Mrs Hilary Johnston's
details so that I could paste special link them into a new spreadsheet

and then do the same for Mr David McCarley?
Thank you
--
Martin
©¿©¬






Com Dist. Family First Name/s Address
Town Post Code


H 3 Johnstone Mr & Mrs J. John & Hilary Downshire Gardens
Carrickfergus BT

D 12 McCarley Mr & Mrs D. David & Muriel Island Road
Ballycarry BT