Hi Guys,
I have a time sheet table which has DATE, PROJ ID, CUST, HRS, WHO columns
I have a pivot table that uses the above table to summarise hours spent on projects. where
- PROJ ID & CUST are used for the row labels
- WHO is used for the column labels
- HRS is used for the SUM data.
I need to be able to filter the pivot table between two dates. The to/from dates can be in cells near the pivot table.
I do not mind using VBA
I do not want the dates to be displayed in the pivot table. I just need to summarise hours against projects between two dates.
I tried to use the DATE data in the Pivot table Report Filter, but that is painful to use.
Can anyone help me
Regards,
Robert
I have a time sheet table which has DATE, PROJ ID, CUST, HRS, WHO columns
I have a pivot table that uses the above table to summarise hours spent on projects. where
- PROJ ID & CUST are used for the row labels
- WHO is used for the column labels
- HRS is used for the SUM data.
I need to be able to filter the pivot table between two dates. The to/from dates can be in cells near the pivot table.
I do not mind using VBA
I do not want the dates to be displayed in the pivot table. I just need to summarise hours against projects between two dates.
I tried to use the DATE data in the Pivot table Report Filter, but that is painful to use.
Can anyone help me
Regards,
Robert