One of my calc spreadsheet contains many sheets. All sheets have a common ID field.
I would like to reference a cell containing a value, which is used to filter all ID fields in every sheets in the calc spreadsheet.
Is this solution possible or do I need a Macro?
Thank you for your support.