Forum Discussion
tilted
Oct 12, 2023Copper Contributor
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...
BlueCollarVending
Oct 12, 2023Copper Contributor
I was dealing with the same issue with a financial report i was building. I had the months spread across multiple tabs and was running into issues. I later redesigned the whole report and took all the months and set them up on a single sheet. But i basically took each month and added a group under that month. So when collapsed, it would only show the month title with a totals cell. When expanded, it showed all the details for that particular month and i was able to add in rows if need to expand the groups volume.