I thought this would already be posted but I can't find it.
I want to filter a pivot table with the date coming from a cell. I have the VBA code but I think it could be done with a simple reference.
I thought this would already be posted but I can't find it.
I want to filter a pivot table with the date coming from a cell. I have the VBA code but I think it could be done with a simple reference.
I think you forgot to attach your sample workbook.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi Ali
It was just a generic type question more than specific to a spreadsheet. If one of the fields selected for a pivot table is, say 'day', how can I select that when I filter the table by referencing a date in, say, cell C2?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks