Excel Sheet Ke Cell Mein Aksar Eik Hi Data Baar Baar Add Karna Parhta Hai tu pochna ye hai
ke Cell Mein 100.15 ya 100.50 Agar 15 ya 50 Likhon tu sath 100 Khud add ho jay aur in Ki Jab
Colaction (+,-,*,/) Kiya Jay tu Ans. Dorost Aana Chahiye.
Excel Sheet Ke Cell Mein Aksar Eik Hi Data Baar Baar Add Karna Parhta Hai tu pochna ye hai
ke Cell Mein 100.15 ya 100.50 Agar 15 ya 50 Likhon tu sath 100 Khud add ho jay aur in Ki Jab
Colaction (+,-,*,/) Kiya Jay tu Ans. Dorost Aana Chahiye.
please explain with example
اس کیلئے آپ شارٹ کٹ کی بنا لے لائک 1 اگر اپ ایک پریس کرتے ہو تو 100 لکھا آجائیے۔۔۔
Matlab Ye Ke Cell Mein Aisa Farmate Ban Jay Ke.
Jab 15 Likhon Tu 100.15 Ban Jay Isi tarha
25 Likhon Tu 100.25
14 Likhon Tu 100.14
Likha Aa Jay.
ابھی تو میں کہی جا رہا ہوں
مگر
آسانی کے لیے آپ کو حل بتا دیتا ہوں
آپ سیل فورمیٹ میں جا کر یہ کام کر سکتے ہیں
اگر میرے واپس آنے تک کسی دوست نے جواب نہیں دیا تو پھر اسکرین شارٹ کے زریعے آپ کی مدد کرتا ہوں آکر
اتنے آپ سیل فورمیٹ سے کرنے کی کوشش کریں
agar aap ko screen shot k mutabiq result column C ya Kisi aur column m chaheye tu asani sa ho jai ga. lekan aap ya chahte hain k column A m he ap entries karain aur aap ka matlooba result aajae tu mujhy bhe nahee pata k kese ho ga (sewae Macro Use karne k). Tu is leye aap Haseeb Sb. k rply ka w8 karain q k mere ilam m bhe izafa ho ga. Lekan mere ak do observation hain.
1. kya hamesha 15,25, ya 14 etc lekhna k matlab ya ho ga k aap 100.xxx he enter kar rahe hain. ya kabhi 200.xxx ya 5555.xxx bhe ho sakta ha
2. Agar 100 k elawa bhe ha tu excel is not smart enogh k aap k zahan ka soch sake k is sa aap ki kya murad ha.
Hope u will explain a bit. Dosra m aap sa ya pochna chahta hon k ya sheet aap kis leye use karain gi. wese he practice k leye ya aap ko offical use karna ha office etc m. Agar aap use btain tu shayad koi dost aap ko bahtar hal d sake ga.
regards
Matalab Ye hai Agar Kisi Cell Mein Bi 15 Likhon Tu 100.15 Usi Cell Mein Ban Jay
Sirf Cell Mein . point ke agey wali raqam Likhon Tu 100 khud likha jay
yani cell formate mein .15 likhon tu 100.15 Show ho..
Follow
1. Right click on sheet1 tab
2. View Code
3. Paste this code on Sheet1 window
this macro will work on range a1:20. Agar aap ko range barhane ho tu opper ki coding m amend kar lain. AAp jab bhe is range m kuch lekh kar enter press karin gi tu 100 automatic add ho jae ga. Formula ya custom formatting sa mujhy nahee pata kese ho ga. agar aap ko code use karne m masla ha tu Hasseb sb. k rply ka w8 karain.Code:Private Sub Worksheet_Change(ByVal Target As Range) Dim dblVal As Double, rngInterest As Range, lngCount As Long On Error GoTo ExitPoint Application.EnableEvents = False Set rngInterest = Intersect(Target, Range("A1:A20")) lngCount = Application.WorksheetFunction.CountA(rngInterest) If lngCount Then dblVal = Val(rngInterest(1).Value) Application.Undo If lngCount = 1 Then rngInterest.Value = (dblVal / 100) + 100 Else MsgBox "Multiple Updates Not Permitted", vbCritical, "Computer Says No" End If End If ExitPoint: Set rngInterest = Nothing Application.EnableEvents = True End Sub
regards
Bohat Shokria
Bookmarks