Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,531
- Office Version
-
- 365
- 2016
- Platform
-
- Windows
I have this PivotTable below:
I wish to use the values of the "column #" (range L22:L28) as values as criteria in a validation list. How can I do this when the length of the column (ie # of displayed rental #s) will be variable based on the changing dataset for which the PivotTable is based?
Jenn
| SportsOps_Data.xls | ||||||
|---|---|---|---|---|---|---|
| L | M | N | O | |||
| 20 | CountofCONTRACT# | Type | ||||
| 21 | CONTRACT# | #N/A | ||||
| 22 | 44226 | 1 | ||||
| 23 | 47211 | 3 | ||||
| 24 | 48334 | 7 | ||||
| 25 | 49157 | 1 | ||||
| 26 | 49297 | 1 | ||||
| 27 | 49756 | 1 | ||||
| 28 | 49872 | 1 | ||||
CRITERIA | ||||||
I wish to use the values of the "column #" (range L22:L28) as values as criteria in a validation list. How can I do this when the length of the column (ie # of displayed rental #s) will be variable based on the changing dataset for which the PivotTable is based?
Jenn
