Dear Team
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
Column A
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.)
12/08/2020 0
13/08/2020 0
14/08/2020 0
Please help me developing the formula..
Bookmarks