Forum Discussion
I have a problem with my NFL schedule
I have a problem with my NFL schedule on a yearly schedule worksheet.
The NFL schedule 2023 file is working.
The schedule 2024 after updating file the yearly schedule worksheet say #Name for oppents 49ers worksheet.
How I update the formula to make it work?
Thanks You
2 Replies
I recall helping you in past but don't recal all the details of your workbook. I do believe you had 'named ranges' like "Schedule" or "YearlySchedule". These names can be found in Name Manager. If you look in the Name Manager for the 2023 and 2024 you can see which Names are missing. you can also look at that formula and see which names are in there and you can highlight those Names and see if it gives values or the #Name error.
It should have value from yearly schedule worksheet as like NFL schedules 2003. I update every year
