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 that is on is called Buttons worksheets
all the teams worksheet schedule will go into D15:E32 cells
I need help put code for all 32 teams schedules in each worksheets
Thanks You
for any help in advance
SF49ers164480
17 Replies
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 ...
