There's a difference between storing and displaying. I build my budgets a year in advance, and I'm assuming that your forecasts will be done in advance as well. In this way, if you want to build JUST a forecast, you can do it easily, or JUST an actual statement as well. We can also use a query to pull them together to display them however we want.
So basically the tables are more targeted which allows better focus and more robust use of your data.
Can you please elaborate on that?
I'm trying different things in Excel, but kinda of messed up, so I'm watching some of Mike's videos. If I get something decent done, I'll post it.