M
Michelle
In Excel 2003, can I use a data-validation drop-down list that reads
its data from a different sheet?
thanks
M
its data from a different sheet?
thanks
M
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Max
As responsed in .misc:
Use a defined range as the source for the DV. Then you can.
p/s: Pl refrain from multi-posting
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
Use a defined range as the source for the DV. Then you can.
p/s: Pl refrain from multi-posting
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
M
Michelle
You say:
How can I post questions to more than one group if I am using google-
groups to post?
I did look for a way.
M
p/s: Pl refrain from multi-posting
How can I post questions to more than one group if I am using google-
groups to post?
I did look for a way.
M
M
Max
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
---
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
---
P
Pete_UK
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
really is no need to repeat your post in multiple groups.
Pete
M
Michelle
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
if you knew how I could avoid it whilst using Google as my posting-
client.
M
M
Max
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
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
D
Don Guillett
ONE group will do as those of us who respond read most of them
S
Shane Devenshire
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
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
M
Michelle
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
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
M
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:
?
!
?
M
topic, and it's very kind of you to explain and all that, but what on
earth makes you say:
That's not the way to get MVP status you know"I'm not sure after all that, that you understand Max's suggestion"
?
!
?
M
M
Max
Love ya
Ahh. Lemme note the above expression first, ahead of all else below
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
---
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
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
---
M
Michelle
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
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
G
Gord Dibben
I use Forte Agent and find it to be a great newsreader.
Gord Dibben MS Excel MVP
Gord Dibben MS Excel MVP
J
John
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
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
J
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
M
Max
I use MS' webpage* and OE
eg: http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
eg: http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
D
Don Guillett
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"
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"
M
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
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
M
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
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
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.