Forum Discussion
Solved
How to change formula automatically when copying down 1 row.
Could anyone help with how I can change date automatically in the formula below when I copy this formula down in excel. =GETPIVOTDATA(" Total sales",'5.Rev-cost food'!$A$1,"Date",DATE(2023,6,24)) A...
- Thanks for the solution I used this and found it does a great job
Most probably PivotTable has Date, like
If so formula could be
=GETPIVOTDATA("Total Sales",'5.Rev-cost food'!$A$1,"date",'5.Rev-cost food'!$A2)and drag it down
Thanks for the solution I used this and found it does a great job
CharlieWR , you are welcome