Hi Joe,
It is the other way around,
sorry i was probably being to fast,
i have a sheet with lots of dropdown boxes that we want to keep as dropdown boxes,
however as the sheet get filled out there are a lot of answers that go together,
for example if you have said the employee is male,
all the drop down boxes that just determine if its a he or a she could be auto filled,
I would normally do this by writing a macro that said something like if cell J7 = male then cell H4 ="He is a valued employee" else" She is a valued employee" for example,
the problem is i inherited this document and all the dropdown option are written into the data validation not in cells and there are hundreds of them
so what i wondering is if i can say to a macro select first / second option of the dropdown list as first is always the male and second the female
so imagine this,
I have about 50 documents to fill out every week,
a lot of that document is company dribble that is always the same, but the person setting it up was so afraid of offending someone by calling them "they" that they have created the entire form with dropdowns to say "HE" or "SHE" everywhere,
now i could rebuild this and add in simple if statements but its going to take me ages,
it would be great if i could just have a "Him Defaults" and "Her Default" Button that i could press and have it go to cell R17 and select 2nd drop down, J21 select 21nd dropdown etc.
now this might not be posible, but before i start doing overtime the week before christmas i thought i'd ask if anyoone knows a way to triger a dropbox box with a macro,
i can do the reast just need the simple bit of getting dropdown box row 1 into the cell?
hope that helps, and thanks for try
Tony