Auto-Fill names based on a Validation?

**NBVC** · 04-28-2010, 10:36 AM

No, I don't think it is macro time

Try this:

In I2 of Setup sheet, enter: =IF(H2='Team Overview (Breakdown)'!$F$3,COUNT($I$1:I1),"")

and copy down to bottom

then in say, G3 of the Team sheet enter: =MAX(Setup!I:I) (you can match font to background colour to hide it)

Then in D5 enter:

=IF(COUNTA($C$5:C5)+1>$G$3,"",INDEX(Setup_Consultants,MATCH(COUNTA($C$5:C5)+1,Setup!$I$2:$I$53,0)))

copy that cell and then paste to each of the other cells in that row to populate.

**Dulanic** · 04-28-2010, 10:58 AM

Small correction to NBVC's post, I2 needs to be,

=IF(H2='Team Overview (Breakdown)'!$F$3,COUNTIF($H$2:H2,H2),"")

and this would be copied down.

The formula was missing the first person under the manager.

**NBVC** · 04-28-2010, 11:01 AM

Thanks for catching that Dulanic,

I just missed a +1...

so formula should be:

=IF(H2='Team Overview (Breakdown)'!$F$3,COUNT($I$1:I1)+1,"")

Note: COUNT() is I think more efficient then COUNTIF()