Printing Multiple Data Validation Lists

M

MWS

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
 
B

Biff

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
 
N

neil40

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)
 
B

Biff

Sorry to contact you this way

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

Biff
 
B

Biff

I updated a thread that you helped me on last week, with a further
Let me see if I can find it!
Click to expand...

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 there:



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"),INDEX(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
 
N

neil40

In Google, if I click on your name, it shows me what you've been doing!
I.E. your latest postings, so it said you'd been in this one 'minutes
ago' !!

Email me at neil40 at btinternet dot com and I'll send you an example

Cheers
Neil
 
Top