Select Group Of Cells Using Data Validation

[rich_cirillo]

Hi

Can groups be selected using Data Validation....I have 3 groups of people....can I have a dropdown list where I select any of the 3 groups and it places the select group names in "Sheet DV" merged cell area

Thanks

Rich

[rich_cirillo]

Can this be done

[Excel Fox]

I would suggest two ways to do this. But my advice would be to avoid merged cells as much as possible.

[rich_cirillo]

That is excellent
I will follow the Alternative version.
Is there a way to stop the cells from being over written....using the "Another Alternative" version where the formula - =IFERROR(INDEX(DVGroup2,ROWS(C$4:C5)),"") can be over written by typing over the names...can this be locked so only the dropdown list can be selected

Also what is the 6,1 at the end of this formula
OFFSET(lists!$A$2,0,MATCH(CurrentGroup2,AllGroups, 0),6,1)

Thanks for your help

Rich

[Excel Fox]

6 is the number of rows for each group, starting from header

1 is the number of columns for each group

You can lock all the cells, except the header cell, and then protect the sheet. This will stop users from overwriting the cell.

XL: How to Lock Individual Cells in a Worksheet (http://support.microsoft.com/kb/214081)

[rich_cirillo]

Thanks again

Another Alternative Sheet - If I want to add another 2 of the dropdown lists down the sheet what is the best way to copy and paste....I want exactly the same dropdown lists down the sheet

Did you color the header of the dropdown list manually and also the Lists manually with the color orange

Thanks again

[Excel Fox]

Yes, I colored them manually. Just copy the entire range to where you want, any number of times.

[rich_cirillo]

Thanks

I try to copy the DV down but have done something wrong as I cannot control the 2 added groups. I need to be able to select any combination in the 3 groups..all box`s can have group 1 or 2 box`s have group 2 and the other box group 3 or box 1 has group 1 , box 2 has group 2 and box 3 has group 3 ...any combinations

Do I need to add to the Name Manager

Thanks