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 have other file I try copy all formulas to my other file it not working what Ineed do
Thanks You
TLS49
Thanks You
TLS49
So that is hard for me to say BUT here are a couple key things to check:
In the 1st formula it looks like I'm referring to the TABLE named FULLSCHEDULE this mean I probably highlighted the data on the 'YEARLY SCHEDULE' worksheet and under Home -> Format as Table and then under the TABLE table named it FULLSCHEDULE. This is a recommended way to work with table data but if you prefer you can replace each reference like FullSchedule[WEEK] with the corresponding cell reference like 'YEARLY SCHEDULE'!A1:A273 and replace the A1:A273 with B1:B273 etc.. for the corresponding column name.
Make sure the tab with the full schedule is still named 'YEARLY SCHEDULE'
Make sure the cells for schedule data are still in the same range
Make sure each tab has the team name in cell A2
In the 1st formula it looks like I'm referring to the TABLE named FULLSCHEDULE this mean I probably highlighted the data on the 'YEARLY SCHEDULE' worksheet and under Home -> Format as Table and then under the TABLE table named it FULLSCHEDULE. This is a recommended way to work with table data but if you prefer you can replace each reference like FullSchedule[WEEK] with the corresponding cell reference like 'YEARLY SCHEDULE'!A1:A273 and replace the A1:A273 with B1:B273 etc.. for the corresponding column name.
Make sure the tab with the full schedule is still named 'YEARLY SCHEDULE'
Make sure the cells for schedule data are still in the same range
Make sure each tab has the team name in cell A2