Create a master table. When I edit that table, it edits all other tables

Hi Tim,

I can look at specific portions of the sheet?

Here is an idea using a filter on a master sheet (table)

Green is placed as Conditional Highlighting for "Show", just as an illustration. Not necessary because you can hide Columns B and C

Formula in the new Column B of Transactions =IFERROR(MONTHNAME(MONTH(A2)),"")

IFERROR places "" (NULL) in a B row that contains no date in A

The added table "Filter" has a Pop-Up Menu

Formula in C of "Transactions" =IF(Filter?::A$1="See all or choose a Month","Show",IF(Filter?::A$1=B2,"Show","Hide"))

So, if you choose a month to filter the Transactions table

Now apply a filter to Transactions

To see this

To see the whole Transactions table again, go to the "Filter" table and choose See all or choose a month

Remember, you can hide Columns B and C

Regards,

Ian.

Tim101691 wrote:

When you say summary views, do you mean I can look at specific portions of the sheet?

What I mean by summary views is the ability to extract summary statistics with SUMIF and its cousins.

You can see an example of that in column C of the SUMMARY BY CATEGORY table on the first sheet of the template. It extracts useful information from the Transactions table on the second sheet.

Aside from summary views you can also easily see subsets of your data using the built-in filtering capability. For example, you can easily do something like this in the Transactions table.

SG

It might be possible with a script, but in general spreadsheets don't "push" changes the way you describe. The tend to "pull" data from cells.

It's usually more efficient to keep like data together in one table rather than scattering it in multiple tables, and then extract summary "views" of that data as needed, either by using the built-in filtering capability, or by SUMIF, SUMIFS functions and the like.

If you're doing a budget, highly recommend you have a look at the Personal Budget template at File > New in your menu. It keeps the data in the 'Transactions' table on the second sheet and shows a summary of that data in the 'Summary by Category' table on the first sheet. It can easily be adapted to your specific needs.

If you need to shows multiple months you might have a look at an "expanded" version saved here (Dropbox download).

SG

HI Ian,

I think you can simplify this formula with OR:

original: IF(Filter?::A$1="See all or choose a Month","Show",IF(Filter?::A$1=B2,"Show","Hide"))

revised: IF(OR(Filter?::A$1="See all or choose a Month",Filter?::A$1=B2),"Show","Hide"))

Or, change the table name from 'Filter?' to 'Show' and the first item of the pop-up menu to 'All' and use this version:

rev. 2: IF(OR(Show::A$1="All",Show::A$1=B2),"Show","Hide"))

Rgards,

Barry

Nice, Barry!

Regards,

Ian.