Forum Discussion
How to automatically update different tabs from master tab in Excel?
All, This seems simple, but I am stuck... I am trying to populate different monthly tabs to look at a budget from entering data in a master spreadsheet. I need this to be based off the date expec...
It is not a very a good idea to keep data of (mostly) identical structure on multiple tabs in an Excel file. Which also means it isn't the best idea to spread the data across multiple tabs.
Why not keep it all in one tab and filter that tab for the month?
Why not keep it all in one tab and filter that tab for the month?