I need help automating summaries from a pivot table.
I have a formula which counts the number of entries which have a date in the past. I then have to manually change the filter for each project type and copy the number of expired projects into a new sheet. Is it possible for these numbers to automatically go into the summary sheet for each project type?
(I have tried to use the "IF" function so I can get the number of dates in the past if the correct project type is selected in the pivot table, but once i select a new project type in the pivot table the number disappears. The code was of the form =IF(A1="PROJECT TYPE",H1,0) where H1 is the cell which counts the number of dates in the past)
Thanks for the help
I have a formula which counts the number of entries which have a date in the past. I then have to manually change the filter for each project type and copy the number of expired projects into a new sheet. Is it possible for these numbers to automatically go into the summary sheet for each project type?
(I have tried to use the "IF" function so I can get the number of dates in the past if the correct project type is selected in the pivot table, but once i select a new project type in the pivot table the number disappears. The code was of the form =IF(A1="PROJECT TYPE",H1,0) where H1 is the cell which counts the number of dates in the past)
Thanks for the help
