1. ## Excel Sheet Formula

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..

2. آپ کی شیٹ پہ کام کر رہی ہوں
دعا کیجئے گا کہ کامیاب ہوں جاؤں
ویسے ایک بات سمجھ نہیں آئی کہ یا تو آپ کو ڈیلی کام کے لیے ہر ایک دن کی الگ شیٹ بنانی ہو گی
یا ایک ہی شیٹ کافی لمبی ہو جائے گی

3. Shireen Shari said:

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..
salam::

1. agar aap date wise alag alag sheets banate hain tu phir tu asan ha aap sirf sumif/sumproduct/ ya even vlookup bhe baz cases m use kar sakte hain.lekan agar aap ya chahte hain k aap har dafa aik he sheet m entry karain jese k ap ki sheet 1 ha tu mere khyal m namumkin tu nahee lekan bohat mushkil hoga. jis par ak member already kam kar rahe hain.
2. aap merge cell use kar rahe hain in ko khatam karain warna aap k leye masla ho ga.
3. aap apna data entry ka layout final kar k share kare k date wise alag sheet ho gi k aik he sheet m entry karin gi. ya aik sheet m aap mazeed sample data enter karian k samajhne m asani ho.

regards,

4. Mein Ne Kochh Data Sheet Mein Example Ke Liye Bi Add Kiya Hai..
Shaid Aap Ko Dakh Kr Samjhne Mein Aasani Ho Gi.
Yani 1st Sheet Ki Date Change ho Tu Uss Date Ke Hisab Se Data Bi
Usi Date Pr 2nd Sheet Mein Aa Jay.

5. Shireen Shari said:
Mein Ne Kochh Data Sheet Mein Example Ke Liye Bi Add Kiya Hai..
Shaid Aap Ko Dakh Kr Samjhne Mein Aasani Ho Gi.
Yani 1st Sheet Ki Date Change ho Tu Uss Date Ke Hisab Se Data Bi
Usi Date Pr 2nd Sheet Mein Aa Jay.
agar m jahan tak aap ki bat samjha hon.

sheet1 m aap ki date b2 m ha aur data row 4 m ha.
agar aap sheet1 m date change karian yani b2 m change karain tu row 4 ka data 2nd sheet m new date k samne add ho jae?

am i right

6. Check This

7. salam Aini::

Good effort, Nice
i have question if u don't mind. ham log aik dosre he sa sekhte hain. m bhe aap sa kuch sekhon ga aur kuch aap mujh sa.

File ki sheet 1 m aap na sare entries manual ki hain,
Sheet 2 m sare entries manual hain. koi bhe formula date ko chek nahee kar raha. agar m koi bhe date sheet2 m change karon tu baqi data wese he rahe ga koi farq nahee pare ga.
jo aap ki sheet m kame ha is par thoda mazeed kam karne k zaroorat ha. hope aap bura nahee mane ge. try to use formulas instead linking cells with "="

8. Yes Bhai U are right..

9. Shireen Shari said:
Yes Bhai U are right..
agar mere bat drust ha tu phir ap jesa chahte hain k sheet1 m entry karte rahin aur data sheet2 m change hota rahe tu asa mumkin nahee. Aap ko phir MACRO use karne pade gi Jis ka m aap ko mashwara nahee donga. Q k aap abhe excel seekh rahe hain tu aap k leye MACRO handle karna masla ho ga. Aur na he aap seekh sakain g.

Aap khod soche jab aap sheet1 k b2 m date enter karain g tu sheet2 m date ko he base bana kar changes hon gi. lekan jab aap B2 ki date change kar dain gi tu sheet2 m bhe new date k age entry ho gi aur purani date ka data lost ho jae ga.

Aap har date k leye ak alag sheet bana lain jesa Aini na kaha ha aap ko. Ya aap apna data layout change karian.

10. ## The Following User Says Thank You to syar For This Useful Post:

sayhellotoit (26th May 2012)

11. may be check this thread. its will help u
http://www.itdunya.com/t310826/

12. syar said:
salam Aini::

Good effort, Nice
i have question if u don't mind. ham log aik dosre he sa sekhte hain. m bhe aap sa kuch sekhon ga aur kuch aap mujh sa.

File ki sheet 1 m aap na sare entries manual ki hain,
Sheet 2 m sare entries manual hain. koi bhe formula date ko chek nahee kar raha. agar m koi bhe date sheet2 m change karon tu baqi data wese he rahe ga koi farq nahee pare ga.
jo aap ki sheet m kame ha is par thoda mazeed kam karne k zaroorat ha. hope aap bura nahee mane ge. try to use formulas instead linking cells with "="
I am agree. Ap formula kon sa laga skty hein es condition mein?? I think linking he option hy. Han hum sheet 2 mein sheet ko lock kar dein tu kaisa idea hy???

13. IamAini said:

I am agree. Ap formula kon sa laga skty hein es condition mein?? I think linking he option hy. Han hum sheet 2 mein sheet ko lock kar dein tu kaisa idea hy???
asal m mujhy layout ka pata nahee k ya kis tarah entry karain gi. aur m index/match, ya sumproduct, sumif use karta.