create a list dependant on info in a column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve - 17 Jun 2007 19:10 GMT

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

Reply to this Message

Max - 18 Jun 2007 02:11 GMT

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.

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Further to my earlier post i am trying to create a list automatically on a
> worksheet drawn from other worksheets.
[quoted text clipped - 4 lines]
> date in it pull the info from col A & B to create a liston the summary
> sheet

Reply to this Message

Steve - 18 Jun 2007 06:01 GMT

Cheers

will send that to the office and have a go

> 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
[quoted text clipped - 7 lines]
> > date in it pull the info from col A & B to create a liston the summary
> > sheet

Reply to this Message

Max - 18 Jun 2007 17:11 GMT

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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Cheers
>
> will send that to the office and have a go

Reply to this Message