Forum Discussion
if statements
I have 12 sheets one for each month of the year. On December on want to show just the year (2019) inA1 then in January I want to show the year (2020) in A1. I would like to do this using and if state...
Hello
As the highly experience and respected Excel MVP, Jan Karel advised, there is no need to have 12 sheet tabs for records for each month. All you need to do is have a single sheet and combine all the information from Jan to Dec. Then, you can use the myriads of functionalities that is available in Excel to analyze your data.
...and that's the "Excel way" of working with spreadsheet.
Regards,
As the highly experience and respected Excel MVP, Jan Karel advised, there is no need to have 12 sheet tabs for records for each month. All you need to do is have a single sheet and combine all the information from Jan to Dec. Then, you can use the myriads of functionalities that is available in Excel to analyze your data.
...and that's the "Excel way" of working with spreadsheet.
Regards,