Thread: Auto transfer data rows to other sheets when certain entries occur
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Auto transfer data rows to other sheets when certain entries o
(Expression 1) In 'Birley City FC', grid A2:
=IF('2007-08 All results'!B2="","",IF(OR('2007-08 All results'!B2="Birley
City FC"),ROW(),""))

Try replacing the above expression with this:
=IF(OR('2007-08 All results'!B2="Birley City FC",'2007-08 All
results'!C2="Birley City FC"),ROW(),"")
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---

Reply With QuoteReply With Quote