Forum Discussion

CharlieWR's avatar
CharlieWR
Copper Contributor
Jun 25, 2023
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...
excel
Formulas and Functions
  • CharlieWR's avatar
    CharlieWR
    Jun 25, 2023
    Thanks for the solution I used this and found it does a great job
Lorenzo's avatar
Lorenzo
Silver Contributor
Jun 25, 2023

Hi CharlieWR 

 

One way:

=GETPIVOTDATA(" Total sales", '5.Rev-cost food'!$A$1, "Date", DATE(2023,6,23)+ROWS($1:1))

it's really DATE(2023,6,23)

Resources