Hello all,
I am trying to make some Data Validation Dependent Lists, but i have a small problem.
The first column in Sheet2 MUST contain some numbers. The problem is that the column B in Sheet1 won't be able to take the data, as long as i have numbers on Sheet2 column A.
I saw that is a know problem, but didn't find any solution.
Any help would be appreciated.
Thank you in advance.
Sheet1
Captur?2.PNG
Sheet2
1.PNG
Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.
Pictures are rarely much use.
Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.
In addition visit Debra's web site here...http://www.contextures.com/xlDataVal13.html#dependent
where you'll learn all you ever need to know on the subject and much much more.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Please download the file from my Drive account (as usual, i cannot upload files...)
https://drive.google.com/open?id=0B9...UdKNXk2eVlZaG8
I need Sheet1/B2 to take dates from Sheet2/B2:B4.
Thank you for Debra's website.
The paperclip attach icon does not work. Use the Manage Attachments option underneath the post area.Originally Posted by julius2017
Have you tried any of Debra's suggestions?
For me it's working.I am trying to make some Data Validation Dependent Lists, but i have a small problem.
The first column in Sheet2 MUST contain some numbers. The problem is that the column B in Sheet1 won't be able to take the data, as long as i have numbers on Sheet2 column A.
See attach.
Last edited by Indi_Ra; 10-03-2017 at 04:48 AM.
I will try to explain a little better the problem.
So, attached you have the file, named "working". Everything it's working just fine.
When i choose something from the sheet named "formular" (example i choose from A2, "doitrei", then i can choose from B2 between "400" and "800"
So everything it's fine.
BUT, if on "sheet1" i try to make some changes, for example in A4 i write a number ex 1234, nothing seem to work...
I have attached two files, to see what is all about.
Thank you.
Your office version is 2016 why you attach file from excel 2003?
Did you look at my attach...
Indi_Ra, yes i saw your attached file, but this is not exactly what i need.
When i select 1234 in sheet1 A3, in sheet1 B2 i must be able to select from 400/800/1200 (sheet2, column B)
When i select 4567 in sheet1 A3, in sheet1 B2 i must be able to select from 800/1600/2400 (sheet2, column C)
My office is 2013 and the original file was created in 2005I will save it as new Office format. Thanx
and here is:My office is 2013
Join Date:01-15-2017
Location:Europe
MS-Off Ver:2016
Posts:20
Did you se this?
http://www.contextures.com/xlDataVal02.html
Hello Indi_Ra and thank you for your patience.
I was at work earlier and there I have 2013 .at home I have 2016.
I saw the link you provided.
As I said, everything works fine as long as i have a text in sheet named "sheet 1", cell A4. When I change to number (this is what I need) is not working anymore.
Please download the file named "not working" and see if you can do something.
Best regards.
Last edited by julius2017; 10-03-2017 at 12:35 PM.
!!
Have you actually looked at Debra's contextures web site and tried to work things out?
Yes i did.
I looked on another sites too and i found the answer:
https://answers.microsoft.com/en-us/...f-9da3a30d52b3
This is what i was asking all day long, if it's possible or not.
I didn't expect someone to do it for me. I just asked if it's possibile
It seems it's not possible...
Best regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks