geospatial
Active Member
- Joined
- Sep 2, 2008
- Messages
- 290
I have set my main worksheet to Format as Table. I have two formulas referencing a column containing dates.
I would like these to change to correlate with the data I have filtered on my main worksheet table, but it still reads all data even after a filter.
On the same lines my PivotTable is setup to use the main worksheet table, and would like it to change it as well depending on the main worksheet filters.
Code:
=MIN(Sheet1B:B)
Code:
=MAX(Sheet1B:B)
I would like these to change to correlate with the data I have filtered on my main worksheet table, but it still reads all data even after a filter.
On the same lines my PivotTable is setup to use the main worksheet table, and would like it to change it as well depending on the main worksheet filters.