create a list dependant on info in a column

[Guest]

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

 

[Max]

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.

 

[Guest]

Cheers

will send that to the office and have a go

 

[Max]

Let us know how it went for you.
Post back in that earlier thread