kinkart
Member
Hello,
I'm facing in any issue in a quite large spreadsheet I created.
In a worksheet (say "worksheet A"), I have a table where in columns B C D E, I have various color choices (say "red", "blue", "green", "black", etc...) and where column F is my helper column, which combine the text value of all my other columns (B C D E).
For example, in column F, I will end up with:
redblue
blackgreenred
redgreen
etc...
I created pivot tables to help sort it all out, where column F is in the Report Filter. Each pivot table is so filtered by color by manually selecting all .
For example, pivot table "GREEN" will only show column that contains "green" since I manually ticked all combos containing "green" in the search field.
But when I enter new data in combination that did not exist before (for example, "greenblack"), the pivot table doesn't show this.
Is there any way to do that automatically, without macros?
I'm facing in any issue in a quite large spreadsheet I created.
In a worksheet (say "worksheet A"), I have a table where in columns B C D E, I have various color choices (say "red", "blue", "green", "black", etc...) and where column F is my helper column, which combine the text value of all my other columns (B C D E).
For example, in column F, I will end up with:
redblue
blackgreenred
redgreen
etc...
I created pivot tables to help sort it all out, where column F is in the Report Filter. Each pivot table is so filtered by color by manually selecting all .
For example, pivot table "GREEN" will only show column that contains "green" since I manually ticked all combos containing "green" in the search field.
But when I enter new data in combination that did not exist before (for example, "greenblack"), the pivot table doesn't show this.
Is there any way to do that automatically, without macros?
