Forum Discussion
How get NFL Yearly Schedule go into Teams worksheets with a button
I have NFL Yearly schedule and have teams worksheet to put teams schedule from Yearly Schedule worksheet. The picture of 49ers team schedule 2021 is it should look like after I press button th...
I suggest you can do this using cell formulas and do it with a single lookup sheet. In the attached I used a FILTER() function (requires Excel 365) and a drop down at the top to dynamically select which team to show.
I do not like on your file. I want same idea in my picture I posted. and put the schedule all 32 teams all at once
sf49ers19238597 I copied the formula to everyone of your tabs ...
I saw problem on your file there is no BYE on the list
Thanks You
sf49ers19238597 good catch. let's try again.