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

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

Cheers

will send that to the office and have a go

"Max" wrote:

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

Let us know how it went for you.
Post back in that earlier thread
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Steve" wrote in message
...
Cheers

will send that to the office and have a go