SHEET 1
A B C D
1 WARD NO SAMPLE DATE
2 1 10 =TODAY()
3 2 20
4 1 30
5 2 40
6 3 50
7 1 60
SHEET 2
A B C D
1 WARD NO
2 DATE 1 2 3
3 SHEET1!D2 =SUMIF(Sheet1!$A$2:$A$7,"=1",Sheet1!$B$2:$B$7) =SUMIF(Sheet1!$A$2:$A$7,"=2",Sheet1!$B$2:$B$7) Sheet1!$A$2:$A$7,"=3",Sheet1!$B$2:$B$7
4 ? ? ? ?
5
6
7
Every Day In Sheet 2 How To Use Same Data Formula For New rows Automatically Data Enter in new rows with sheet 1 D2 date.
when sheet 2 first rows ( A3 : D3 ) ready with today date then delete data from sheet1 but sheet 2 data not deleted and next day same formula use in new rows (A4 : D4 ) how it’s possible ?
In sheet 1! D2 cell i used =today () formula.
Bookmarks