Data Validation List from different sheet

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

In Excel 2003, can I use a data-validation drop-down list that reads
its data from a different sheet?

thanks

M
 
Multi-posting means separately posting the same question in more than one
excel newsgroup. You posted here and you posted again the same question in
..misc. This would potentially waste responders' time to answer a question
which might already been answered by other responders in the other
newsgroup.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
 
Many contributors look at posts in a range of Excel groups, so there
really is no need to repeat your post in multiple groups.

Pete
 
I didn't ask what multi-posting meant, that was self-evident. I asked
if you knew how I could avoid it whilst using Google as my posting-
client.

M
 
So that earlier gentle refrain irked you more than the substance in the
response which was given? I'm disappointed. I don't think using google to
post has anything to do with multi-posting. Did you not post twice,
separately, the same question, to 2 different excel newsgroups?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
 
Hi,

I'm not sure after all that, that you understand Max's suggestion -
basically to use a range on another sheet you must name the range. Select
the range and click in the Name Box (to the left on the Formula Bar) type a
name without spaces and press Enter. (this last step is critical). Then go
to the sheet that you want the data validation in and when you get to the
List, Source enter =MyName (whatever name you gave your range).

If this helps, please click the Yes button,

Cheers,
Shane Devenshire
 
No, you're mistaken again Max. I was not in the slightest bit irked by
your reminder not to multi-post, it's a fair point. What cracked us
all up was the fact that you chose not to address my question, but
instead you decided to hector and patronise me with an explanation
that I had made clear was not necessary. Now I know I'm only a simple
woman and that my hormones get me all messed up sometimes, but it's
not that time of the month yet, and I was (and still am) genuinely
interested to know how I can post the same question to more than one
group if I'm using Google. I'm looking forward to you answering a
different question ;-)

Love ya

Michelle
 
Now, there's been some predictably patronising responses on this
topic, and it's very kind of you to explain and all that, but what on
earth makes you say:
"I'm not sure after all that, that you understand Max's suggestion"
Click to expand...
That's not the way to get MVP status you know

?
!
?

M
 
Love ya
Ahh. Lemme note the above expression first, ahead of all else below
I was (and still am) genuinely interested to know
how I can post the same question to more than one
group if I'm using Google
Click to expand...

I seldom use google to post, but here's what I just refreshed on ..

In google groups,
when one clicks the "+New post" button (at the bottom of the page)

In the posting page which opens
In the "To Newsgroups:" box, believe* one can enter multiple groups, eg:
microsoft.public.excel, microsoft.public.excel.misc
*there's actually a guideline stated there which reads:
(Separate multiple groups with commas)

(but I've never cross-posted before in asking a question)

Forget-me-not:
I recollect venturing an answer to your original question on the DV
ahead of the oomph-lah bit on multi-posting

Are you happy with the above?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
 
Excellent answer - Thank you very much, and thank you too for your
original response which was spot-on and to the point.

Now we have this ongoing conversation, can I ask you another question,
I find myself using Newsgroups more these days, can you recommend a
good newsreader? What do the MVPs and guys who use it a lot use? I
find both Google and Outlook Express a bit clunky.

Thanks

M
 
Michelle, Michelle
I think your jumping the gun here, if you read regularly these post,
you'll notice that Shane is excellent not just at giving answers but giving
proper explanation, that said maybe you don't need it but others like me and
thousands others appreciate the explanation.
Max's answer was direct and straight to the point, and then everything
got sidetrack with "multi posting".
I touch it was nice of here to give a full explanation.
Regards
John
 
Sorry for the typo.!!
John said:
Michelle, Michelle
I think your jumping the gun here, if you read regularly these post,
you'll notice that Shane is excellent not just at giving answers but
giving proper explanation, that said maybe you don't need it but others
like me and thousands others appreciate the explanation.
Max's answer was direct and straight to the point, and then everything
got sidetrack with "multi posting".
I thought it was nice of him to give a full explanation.
Regards
John
Click to expand...
 
That's not the way to get MVP status you know

Shane has been an MVP for a long time and is one of the most knowledgeable
responders. A lot of my knowledge is from people like Shane.

You flippant attitude is no way to "win friends and influence people"
I suggest if you want continued help here you learn to cooperate.

Happy Thanksgiving and "Hook em horns"
 
It's true - I am sorry. Most things I say, I say with a smile, but of course
that doesn't come across on email. I sort of expect everyone to know where
I'm coming from, and I really didn't mean to offend. But he and you didn't
know that, so I apologise. I also have to remember that I have my own
ongoing problems trying to make a way for myself in a man's world, and Shane
was probably getting a 'dig' that he didn't deserve. I guess I should
probably work through my issues rather than take it out on anyone else.

Hard though it is to hear, thanks for reminding me to remember my manners.

And I do really appreciate everyone's help, these communities are a
fantastic support for everyone in the industry.

Michelle
 
It's true - I am sorry. Most things I say, I say with a smile, but of course
that doesn't come across on email. I sort of expect everyone to know where
I'm coming from, and I really didn't mean to offend. But he and you didn't
know that, so I apologise. I also have to remember that I have my own
ongoing problems trying to make a way for myself in a man's world, and Shane
was probably getting a 'dig' that he didn't deserve. I guess I should
probably work through my issues rather than take it out on anyone else.

Hard though it is to hear, thanks for reminding me to remember my manners.

And I do really appreciate everyone's help, these communities are a
fantastic support for everyone in the industry.

Michelle
 
Back
Top