Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If you use an if statement for the filter, the values selected in that sheet will not be carried over to other sheets.
I want to take over the data by pressing the button.
On sheet A I select TableA.region, but on sheet B I want to have the same data selected if TableA.region selected on sheet A matches data in TableB.region.
How should I solve this?
You can use selection bookmark
Click "Add Bookmark" and give the bookmark a name.
In Sheet B, create a filter for TableB.region that matches the selected value(s) in TableA.region.
Add a button to Sheet A that triggers the action "Apply Bookmark" and selects the bookmark created in first step
Bookmarks are set, and there is a part that is specified in advance so that the filter item will be selected when the sheet is first opened.
In this case, does it mean that this time should be added to the originally specified bookmark?