Forum Discussion
Solved
I need help with a formula on nfl schedule file. I have other file is run by vba.
2022 NFL schedule file will show you idea look at this file first. It is run by vba code. This will give you Idea looking for file called NFL schedule will using formulas instead of vba.
The file NFL Schedule in 1-18 worksheets put data from yearly schedule.
Thanks you very much
sf49ers19238597 hello again. i have attached a workbook with the needed formulas. I added the WeekNumber in cell J1 because you need to have what week you want somewhere on that sheet (unfortunately we can't pull sheet name easily/reliably).
Hello sf49ers19238597,
Thank you for reaching out with your question about the NFL schedule file and VBA code. I'd be happy to assist you with finding a solution.
If I understand correctly, you have a file called "NFL Schedule" with 1-18 worksheets that contain data from the yearly schedule. It appears that you would like to explore using formulas instead of VBA code for this file. Is that correct?
To begin, I recommend examining the structure and requirements of your VBA code. Take note of the specific functions and logic it employs to populate the data in the worksheets. Once you have a clear understanding of the existing code, you can start transitioning to formulas.
Formulas in Excel can perform a wide range of calculations and manipulations on data. They offer flexibility and can often simplify complex tasks. To replicate the functionality of your VBA code using formulas, you will need to identify the specific operations performed by the code and find the appropriate functions and formulas to achieve the same results.
If you can provide more details about the specific functionality of your VBA code and the desired outcome, I can offer more specific guidance on how to implement the formulas. Feel free to share any specific challenges you are facing, and I'll do my best to assist you.
Looking forward to your response!
Best regards,
sf49ers19238597 hello again. i have attached a workbook with the needed formulas. I added the WeekNumber in cell J1 because you need to have what week you want somewhere on that sheet (unfortunately we can't pull sheet name easily/reliably).
Thanks you help. Why change formula in Bye week teams section? I had look at bye week worksheet. when I make change new season it would change on 1-18
Thanks you
- I wasn't sure where that data came from and if it was updated or not so the formula was easy to calculate it so no additional sheet and no extra work filling that in is needed.
