Hello All, If this is possible, please tell me how.

To activate multiple cells that contain different data lists, via Data
Validation, so that all of the entries, of each data list, can be displayed
at one time.

I am putting a presentation together and would like to print the worksheet
that contains the various Data Validation menus and the content of those
menus, but cannot figure out how to do it OR if it is at all possible.

Any and All Help Is Appreciated - Thank You

Hi!

I don't think this is possible.

About the only thing I can think of is to temporarily change your data
validation drop downs to list boxes. Make sure you select Print object on
the Properties tab.

Biff

"MWS" wrote in message
...
Hello All, If this is possible, please tell me how.

To activate multiple cells that contain different data lists, via Data
Validation, so that all of the entries, of each data list, can be
displayed
at one time.

I am putting a presentation together and would like to print the worksheet
that contains the various Data Validation menus and the content of those
menus, but cannot figure out how to do it OR if it is at all possible.

Any and All Help Is Appreciated - Thank You

Biff

Sorry to contact you this way but your email bounces! (the one that
Google Groups shows me anyway.
I updated a thread that you helped me on last week, with a further
question (How to pick out Home/Away results from a fixture list)

Cheers
Neil (Apologies to the originator of this thread)

Biff wrote:
Hi!

I don't think this is possible.

About the only thing I can think of is to temporarily change your data
validation drop downs to list boxes. Make sure you select Print object on
the Properties tab.

Biff

"MWS" wrote in message
...
Hello All, If this is possible, please tell me how.

To activate multiple cells that contain different data lists, via Data
Validation, so that all of the entries, of each data list, can be
displayed
at one time.

I am putting a presentation together and would like to print the worksheet
that contains the various Data Validation menus and the content of those
menus, but cannot figure out how to do it OR if it is at all possible.

Any and All Help Is Appreciated - Thank You

I updated a thread that you helped me on last week, with a further
question

Let me see if I can find it!

Biff

wrote in message
oups.com...
Biff

Sorry to contact you this way but your email bounces! (the one that
Google Groups shows me anyway.
I updated a thread that you helped me on last week, with a further
question (How to pick out Home/Away results from a fixture list)

Cheers
Neil (Apologies to the originator of this thread)

Biff wrote:
Hi!

I don't think this is possible.

About the only thing I can think of is to temporarily change your data
validation drop downs to list boxes. Make sure you select Print object on
the Properties tab.

Biff

"MWS" wrote in message
...
Hello All, If this is possible, please tell me how.

To activate multiple cells that contain different data lists, via Data
Validation, so that all of the entries, of each data list, can be
displayed
at one time.

I am putting a presentation together and would like to print the
worksheet
that contains the various Data Validation menus and the content of
those
menus, but cannot figure out how to do it OR if it is at all possible.

Any and All Help Is Appreciated - Thank You

Sorry to contact you this way

How 'da heck did you happen to find me in this thread? <bg

Biff

wrote in message
oups.com...
Biff

Sorry to contact you this way but your email bounces! (the one that
Google Groups shows me anyway.
I updated a thread that you helped me on last week, with a further
question (How to pick out Home/Away results from a fixture list)

Cheers
Neil (Apologies to the originator of this thread)

Biff wrote:
Hi!

I don't think this is possible.

About the only thing I can think of is to temporarily change your data
validation drop downs to list boxes. Make sure you select Print object on
the Properties tab.

Biff

"MWS" wrote in message
...
Hello All, If this is possible, please tell me how.

To activate multiple cells that contain different data lists, via Data
Validation, so that all of the entries, of each data list, can be
displayed
at one time.

I am putting a presentation together and would like to print the
worksheet
that contains the various Data Validation menus and the content of
those
menus, but cannot figure out how to do it OR if it is at all possible.

Any and All Help Is Appreciated - Thank You

I updated a thread that you helped me on last week, with a further
question

Let me see if I can find it!

Hmmm.....

This is strange! I've found the thread and in my newsreader mine is the last
reply of that thread. So I used Google and your reply is the



Biff (or anyone)

I've got this working well, and have decided to use it on a more
comprehensive fixture list, which includes both League and Cup
fixtures.


There will be a two stage 'filter', firstly to pick out all League
fixtures, then to do the Home and Away 'filter'.
I can pick out the League matches using a similar formula to that which
you posted, BUT, there are lines missing in the resultant table/array -
the cup matches.
Is there a way to get round this so that all the lines are written one
after the other without gaps?
Current code to select the League matches is
{=IF(ROWS($17:17)<=COUNTIF($C$17:$C$67,"ELC"),INDE X(B$17:B$67,SMALL(IF($C$1*7:$C$67="ELC",ROW(B$17:B $67)-ROW(B$17)+1),ROWS($17:17))),"")}

Well, I'd have to see the file to figure out EXACTLY what you mean!

If you'd like me to look at your file then let me know how to contact you.

Biff


"Biff" wrote in message
...

I updated a thread that you helped me on last week, with a further
question

Let me see if I can find it!

Biff

wrote in message
oups.com...
Biff

Sorry to contact you this way but your email bounces! (the one that
Google Groups shows me anyway.
I updated a thread that you helped me on last week, with a further
question (How to pick out Home/Away results from a fixture list)

Cheers
Neil (Apologies to the originator of this thread)

Biff wrote:
Hi!

I don't think this is possible.

About the only thing I can think of is to temporarily change your data
validation drop downs to list boxes. Make sure you select Print object
on
the Properties tab.

Biff

"MWS" wrote in message
...
Hello All, If this is possible, please tell me how.

To activate multiple cells that contain different data lists, via Data
Validation, so that all of the entries, of each data list, can be
displayed
at one time.

I am putting a presentation together and would like to print the
worksheet
that contains the various Data Validation menus and the content of
those
menus, but cannot figure out how to do it OR if it is at all possible.

Any and All Help Is Appreciated - Thank You