Excel Sheet Formula

[Shireen Shari]

Mujhey Ye Pochhna Hai.
Ager Excel Ki 1 File Mein 2 Sheets Hoon.
Aur 1st Sheet mein Rozana Ke Kaam ki Sumary Hai.
Aur 2nd Sheet Mein Date wise Monthly Sumary Hai.

1st sheet ka DATA 2nd Sheet Mein Jis Date Ko Add
Kiya Jay 2nd Sheet Mein Bi Usi Date Ko Wohi DATA Aa Jay.
Aur Jis Tarha Date Change Ho.Usi Tarha 2nd Sheet Mein Bi Usi Date Pr
DATA Apne Aap Aa Jay..

Exampal
1 Sheet Mein Rozana DATA Add Kiya Jata Hai.
Aur 2nd Mein Porey Month Ki Date (1..30) Hai ...
1st Date Ko Data 1st Sheet Mein Add Kiya.
Wohi Data 2nd Sheet Mein 1st Date Pr Aa Jay.
Aur Jab Month Ki 2nd DAte Ho.2nd Date Ka Data Month
Ki 2nd Date Pr Aa Jay.
Sheets Sirf 2 Hi Hain.

Koi Aisa Farmula Bta Dain Jo Date Se Conected Ho..