Hi all, I have problem with this:
I have 2 cells A1 and A2, If A1 value is RA then in A2, i can choose values from data validation list VAL_RA, else if A1 is GA, in A2 i can choose values from data validation list VAL_GA.
What i need is a button macro who will change values what i choose from data validation list in cell A2, down, from appropriate validation list. Example If a choose 5th value from validation list for cell A2, by click on macro button i ll get 4th value, another click i ll get 3rd etc... Of course if u have time i ll need reverse macro too, for getting upper values from list.
thank you
I have 2 cells A1 and A2, If A1 value is RA then in A2, i can choose values from data validation list VAL_RA, else if A1 is GA, in A2 i can choose values from data validation list VAL_GA.
What i need is a button macro who will change values what i choose from data validation list in cell A2, down, from appropriate validation list. Example If a choose 5th value from validation list for cell A2, by click on macro button i ll get 4th value, another click i ll get 3rd etc... Of course if u have time i ll need reverse macro too, for getting upper values from list.
thank you
