Put week number in many worksheets

[VOYAGER22]

I need help with put week 1-18 where bye week team by a formulas. I have 32 teams main worksheet in cell H8.

I also have some worksheets for friends i need help with put week 1-18 in cell E2.


Get data from Bye Weeks worksheet to put in other worksheets. I put data in by manually. I want it automatically without do in manually.

for sample I want look like this WEEK 6 for all week just because move other week because something happen.


Thanks You Voyager22

[Bernie Deitrick]

Group all your sheets (except the first one) and in cell H8 use the formula

="WEEK "&INDEX($A$15:$A$32,MATCH("BYE",D15#,FALSE))