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...
Why use a sheet for each month? Excel makes your life a whole lot simpler if you put your data into one long table with a date column. If you do that, you make summarizing your data a lot simpler.
JKPieterse I use a sheet for each month because the sheet is a budget sheet for each month
- That in itself is not a very good reason for putting the info an a separate sheet for each month if you ask me. I promise you, reporting becomes very simple of your data is on one sheet. You can then use a pivot table to summarize very easily. And if you want to view one month you can filer your table to that month.
Jan I am sorry for the inconvenience , But I, believe you are saying is that I would need a column for my projected income, actual income then I would need a individual column for medical projected, medical actual, the difference between the two, and the same for housing expenses, entertainment expenses, pet expenses, etc.
Then set this same thing up for each month
Wouldn’t that be confusing for someone doesn’t work with Excel a great deal. Is there a way you can show me what you are trying to explain.
