Malcolm1978
New Member
- Joined
- Jan 31, 2007
- Messages
- 30
Hi,
I have a pivot table with a report filter which I'd like to filter by a range.
The filter is a range of numbers between 1 and 150. What I want to do is some VBA where if a user enters a number into a cell (e.g. 50) that all the numbers between 1 and 50 are filtered.
Is this possible?
I have a pivot table with a report filter which I'd like to filter by a range.
The filter is a range of numbers between 1 and 150. What I want to do is some VBA where if a user enters a number into a cell (e.g. 50) that all the numbers between 1 and 50 are filtered.
Is this possible?
