Hi Experts,
please help me fix my problem. I would like cells D3 and E3 (sheet "validation") to auto update when I change value in validation list on C3 eg. prevoius year was 2017, I have changed C3 to 2016, but values in D3 and E3 didn't update to jan-16 and feb-16.
Thaks for help.
Your cell value is static (the value selected from dropdown is permanent)
- and so needs either a "change" macro or a formula to reflect the change when you select a different year
see row 10 in attached workbook for a "formula" solution
Last edited by kev_; 03-30-2017 at 04:07 AM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Hi wrybel
Not sure if this is what you are looking for...Check out Validation Sheet
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Hi,
unfortunately yours solution are not enought. Look at this post http://www.ashishmathur.com/automati...-list-changes/, here is almost what I want, but the problem is that, the values in validation update only after manual cell change. Do you have any other solution ?
Thanks for your current help.
Where are you getting the month value for Month A and Month B
There are from data sheet range D2:D13. Is that what you mean?
Why does the validation cell itself need to change?
Why can you not use a cell with a formula in it? It achieves exactly the same result
Okay, however, on your validation sheet, there is no dropdown for month?Originally Posted by wrybel
I agree with Kev_ on this one.
Because later I will need validation list in D3 and E3 for further actions, like choosing values depend on this cells.
Perhaps it would be better if you attached a new workbook which explains everything you are trying to achieve so that we can look at the "whole" picture.
We need to understand which cell is dependant on another and what you want to happen to each cell in the whole chain
It sounds as though dependant dropdowns (achieved by using a combination of Named Ranges and the Indirect Function) will get you what you want
thanks
In the meantime have a look at the attached workbook
- may not be quite what you want - but is an excellent twist on the normal way to achieve dropdowns
Adapted from something I found at Jerry Beaucaire's excellent site
Beaucaire.jpg
Last edited by JBeaucaire; 12-26-2019 at 03:49 PM.
This can only be achieved through VBA, probably why it's in the VBA forum.
Here is my published solution for this common goal: DV-UpdatePriorChoices
The macro solution watches for a DV selection to be made, then immediately replaces that choice with a formula that gives the same result. This way if you change your source list, the prior choices will update to show the new value in the same positions from the list.
To use the code as is, you simply need to create a named range for the months, then
Last edited by JBeaucaire; 12-26-2019 at 03:49 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
JBeaucaire, this is excactyly what I need. Thanks a lot. kev and sintek thanks for your support.
You are welcome. Thanks for rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks