Exel Mein No. Data

[Shireen Shari]

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.

[syar]

please explain with example

[*Black*Beauty*]

اس کیلئے آپ شارٹ کٹ کی بنا لے لائک 1 اگر اپ ایک پریس کرتے ہو تو 100 لکھا آجائیے۔۔۔

[Shireen Shari]

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.

[Haseeb Alamgir]

ابھی تو میں کہی جا رہا ہوں
مگر
آسانی کے لیے آپ کو حل بتا دیتا ہوں
آپ سیل فورمیٹ میں جا کر یہ کام کر سکتے ہیں
اگر میرے واپس آنے تک کسی دوست نے جواب نہیں دیا تو پھر اسکرین شارٹ کے زریعے آپ کی مدد کرتا ہوں آکر
اتنے آپ سیل فورمیٹ سے کرنے کی کوشش کریں

[syar]

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

[Shireen Shari]

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

[syar]

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

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

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.

regards

[Shireen Shari]

Bohat Shokria

[IT.BOY]

Bohat Shokria