Thanks - between your reply and Pete's I now have my resolution - is there
any way i can use Conditional Formatting to hide the 'not applicable'
responses?
--
Thanks and have a good day

Ruth


"bj" wrote:

one way would be to enter your pair criteria in columns A abd B in a new
sheet (Sheet2)
In C1 enter
=SUMPRODUCT(--(Sheet1!A$1:A$64000=A1),--(Sheet1!B$1:B$64000=B1)*ROW(A$1:A$64000))
and copy down as far as you need
In D1 enter
=OFFSET(Sheet1!$A$1,$C1-1,COLUMN()-4)
copy over to AC1 and down as far as you need.

"RWilliams" wrote:

I have a large amount of data out of Project and i want to search for a row
that satisfies 2 specified criteria from column A and B and copy and paste
the information for that row (columns A to X) into a particular position on
another sheet ... I need to do this for approximatley 100 sets of criteria so
do not want to do it manually if i can help it .... I am not even sure where
to start with this ... if anyone has any thoughts I would be happy to try
....???
--
Thanks and have a good day

Ruth