Is there a way for a pivot table to be filtered from a cell that is located on another sheet within the workbook?
This cell is a drop down that populates other data, so in this instance I am trying to get the pivot table's filter to reference that criteria.
Excel 2007
This cell is a drop down that populates other data, so in this instance I am trying to get the pivot table's filter to reference that criteria.
Excel 2007
