See response to your last reply to Shane in your earlier posting, for one
way using simple non-array formulas to "pull up" the results in the summary
sheet.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Steve" wrote in message
...
Further to my earlier post i am trying to create a list automatically on a
worksheet drawn from other worksheets.

I have 12 monthly worksheets and a summary page

I want to get Excell to look in a column F on each month and if it has a
date in it pull the info from col A & B to create a liston the summary
sheet