Home UrduPad EMail FAQ ITD Mobile
 Pakistani Urdu Forum for Free IT Education, ITDunya.com Solved Excel Sheet Formula
 Register Calendar Mark Forums Read

 Solved Problems (IT) All Solved Problems should move here.....

Excel Sheet Formula
#1
25th May 2012, 07:47 PM
 Member Last Online: 17th January 2014 08:22 PM Join Date: 13 Aug 2009 Location: Faisalabad Gender: Female Posts: 94Started threads: 18 Thanks: 3 Thanked 4 Times in 4 Posts Thread Starter
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..
Attached Files
 Data.xls (17.5 KB, 235 views)
#2
25th May 2012, 08:48 PM
 Advance Member Last Online: 17th March 2013 12:55 PM Join Date: 21 Apr 2012 Location: Pakistan Age: 16 Gender: Female Posts: 3,134Started threads: 76 Thanks: 102 Thanked 322 Times in 192 Posts

آپ کی شیٹ پہ کام کر رہی ہوں
دعا کیجئے گا کہ کامیاب ہوں جاؤں
ویسے ایک بات سمجھ نہیں آئی کہ یا تو آپ کو ڈیلی کام کے لیے ہر ایک دن کی الگ شیٹ بنانی ہو گی
یا ایک ہی شیٹ کافی لمبی ہو جائے گی
#3
25th May 2012, 09:08 PM
 Advance Member Last Online: 23rd September 2014 06:56 PM Join Date: 31 Jul 2009 Location: Nowshera(KP) Age: 37 Gender: Male Posts: 791Started threads: 9 Thanks: 2 Thanked 326 Times in 282 Posts

Quote:
 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
25th May 2012, 09:31 PM
 Member Last Online: 17th January 2014 08:22 PM Join Date: 13 Aug 2009 Location: Faisalabad Gender: Female Posts: 94Started threads: 18 Thanks: 3 Thanked 4 Times in 4 Posts Thread Starter

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
25th May 2012, 09:46 PM
 Advance Member Last Online: 23rd September 2014 06:56 PM Join Date: 31 Jul 2009 Location: Nowshera(KP) Age: 37 Gender: Male Posts: 791Started threads: 9 Thanks: 2 Thanked 326 Times in 282 Posts

Quote:
 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
25th May 2012, 09:52 PM
 Advance Member Last Online: 17th March 2013 12:55 PM Join Date: 21 Apr 2012 Location: Pakistan Age: 16 Gender: Female Posts: 3,134Started threads: 76 Thanks: 102 Thanked 322 Times in 192 Posts

Check This
Attached Files
 Data.xls (37.5 KB, 146 views)
#7
25th May 2012, 10:00 PM
 Advance Member Last Online: 23rd September 2014 06:56 PM Join Date: 31 Jul 2009 Location: Nowshera(KP) Age: 37 Gender: Male Posts: 791Started threads: 9 Thanks: 2 Thanked 326 Times in 282 Posts

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
25th May 2012, 10:03 PM
 Member Last Online: 17th January 2014 08:22 PM Join Date: 13 Aug 2009 Location: Faisalabad Gender: Female Posts: 94Started threads: 18 Thanks: 3 Thanked 4 Times in 4 Posts Thread Starter

Yes Bhai U are right..
#9
25th May 2012, 10:16 PM
 Advance Member Last Online: 23rd September 2014 06:56 PM Join Date: 31 Jul 2009 Location: Nowshera(KP) Age: 37 Gender: Male Posts: 791Started threads: 9 Thanks: 2 Thanked 326 Times in 282 Posts

Quote:
 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.
 The Following User Says Thank You to syar For This Useful Post: sayhellotoit (26th May 2012)
#10
25th May 2012, 10:21 PM
 Advance Member Last Online: 23rd September 2014 06:56 PM Join Date: 31 Jul 2009 Location: Nowshera(KP) Age: 37 Gender: Male Posts: 791Started threads: 9 Thanks: 2 Thanked 326 Times in 282 Posts

may be check this thread. its will help u
Need Count formula help in Excel (advance thanks)
#11
25th May 2012, 10:24 PM
 Advance Member Last Online: 17th March 2013 12:55 PM Join Date: 21 Apr 2012 Location: Pakistan Age: 16 Gender: Female Posts: 3,134Started threads: 76 Thanks: 102 Thanked 322 Times in 192 Posts

Quote:
 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???
#12
25th May 2012, 10:29 PM
 Advance Member Last Online: 23rd September 2014 06:56 PM Join Date: 31 Jul 2009 Location: Nowshera(KP) Age: 37 Gender: Male Posts: 791Started threads: 9 Thanks: 2 Thanked 326 Times in 282 Posts

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

 Bookmarks

 (View-All)  Members who have read this thread in the last 15 days : 1 Kunwar
 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are Off Refbacks are Off Forum Rules