I put a formula =IF(A3=$A$1,PFL!AB202,0) that gives me 782.9 values from other sheet. now the nex day 11/8/2020 i want to retain 782.9 but against date 11/08/2020 it should be changed in front of 11/08/2020
10/08/2020 (date will be changed auto to next date)
10/08/2020 782.9 (data to be retained for next date
11/08/2020 0 (Next data should be here but i want to keep above data also, it will give me whole month fig. date wise.)
Please help me developing the formula..