formula chahiye

**alim khan** · 7th July 2011, 03:39 PM

stock mein se sale (sheet 1) atomatic minus ho jaye koi formula batain.

**Friend_Sania** · 7th July 2011, 03:55 PM

ye check karain

**Friend_Sania** · 7th July 2011, 03:56 PM

farmula ye hai
=MIN(Sheet1!G7)

**syar** · 7th July 2011, 05:18 PM

Salam:;

I have 2 questions before answer

1. Sale wale sheet me aik he date m items repeat ho rahe hain yani Code 25A cell G11 me bhe ha aur G18 me bhee ha kya ya aap total karna chahte ho yani 5 Jan ki total sale 25A k leye 13 ho ge. explain a bit

2. Stock ke sheet me bhe aap ka item code repeate ho rahe hain. tu aap ka out put result kya ho ga yani aap kis tarah result chahte hain. Zra file m apni out put attach kar ke batain. k aap date wise sale ya fortnightly sale chahte ho. please explain a bit

Regards

**alim khan** · 8th July 2011, 01:31 PM

syar said:

Salam:;

I have 2 questions before answer

1. Sale wale sheet me aik he date m items repeat ho rahe hain yani Code 25A cell G11 me bhe ha aur G18 me bhee ha kya ya aap total karna chahte ho yani 5 Jan ki total sale 25A k leye 13 ho ge. explain a bit

2. Stock ke sheet me bhe aap ka item code repeate ho rahe hain. tu aap ka out put result kya ho ga yani aap kis tarah result chahte hain. Zra file m apni out put attach kar ke batain. k aap date wise sale ya fortnightly sale chahte ho. please explain a bit

Regards

stock mahine mein ek bar liya hai lekin sale roz minus karni hai.jaise tally mein hota hai kya excel` mein yeh ho sakta hai.

**syar** · 8th July 2011, 02:22 PM

ok. kya aap aik he item ka data file me lekh kar file upload kar sakte hain.
aap sumif, index,match ka formula bhe istimal kar sakte hain.

regards,

**sajjad_abid60** · 8th July 2011, 02:57 PM

ya check kro

**alim khan** · 18th July 2011, 11:42 PM

alim khan said:

stock mahine mein ek bar liya hai lekin sale roz minus karni hai.jaise tally mein hota hai kya excel` mein yeh ho sakta hai.

attachment dekhein.

**AtifRaza** · 19th July 2011, 01:24 AM

alim khan said:

attachment dekhein.

Well yeh directly possible nahe hai ke aik cell pr ki value pr function perform krwana aur usi cell main result store krwana.

It is possible through MACROS. Main ne ap ki excel file main thori changes ki hain aur aik macro internet se mila tha mujhey jo main ne ap ki requirement ke mutabiq cell adresses aur formula wagera change kr ke embedd kr deya hai.

Simple ap Stock ki value enter krtay jain, wo auto calculate ho kr STOCK ke usi cell main aa jaye gi!

Note: Main ne MACRO main cell adresses ko G7:G100 - H7:H100 tk configure kya hai. Macro main onChange event use kya geya hai jis ki waja se jab bhi ap G7 se le kr G100 cells main koe value ap change krain gay to wo us ke sath walay H Column ke cell se subtract ho gi aur result wapis G column ke cell main aa jaye ga.

Kindly excel file open krnay pr jab wo Enable Macro ki option de to allow kr dejeye ga!

Regards,

**alim khan** · 20th July 2011, 01:19 AM

AtifRaza said:

Well yeh directly possible nahe hai ke aik cell pr ki value pr function perform krwana aur usi cell main result store krwana.

It is possible through MACROS. Main ne ap ki excel file main thori changes ki hain aur aik macro internet se mila tha mujhey jo main ne ap ki requirement ke mutabiq cell adresses aur formula wagera change kr ke embedd kr deya hai.

Simple ap Stock ki value enter krtay jain, wo auto calculate ho kr STOCK ke usi cell main aa jaye gi!

Note: Main ne MACRO main cell adresses ko G7:G100 - H7:H100 tk configure kya hai. Macro main onChange event use kya geya hai jis ki waja se jab bhi ap G7 se le kr G100 cells main koe value ap change krain gay to wo us ke sath walay H Column ke cell se subtract ho gi aur result wapis G column ke cell main aa jaye ga.

Kindly excel file open krnay pr jab wo Enable Macro ki option de to allow kr dejeye ga!

Regards,

lekin bhai mai to rozana H Column mein hi entry karunga aur is mein copy pest karne per formula kam nahi kar raha hai.

**AtifRaza** · 21st July 2011, 04:05 PM

Brother CELL se formula's copy ho gatay hain MACROS nahe. Main ap ko is MACRO ko configure krna batata hun....

For Example "H" Column Stock hai, "I" Column Sale ka hai. H4 wo cell hai jahan se main ne stock ki value dalni start krni hai aur H20 cell tk stock ka data ja sakta hai. Is situation main ap ka MACRO yeh ho ga..

Code:

Private Sub Worksheet_Change(ByVal Target As Range)

  If Not Intersect(Range(Target.Address), Range("H4:H20")) Is Nothing Then

     Application.EnableEvents = False

       Range("H" & Target.Row).Value = Range("H" & Target.Row).Value _
         - Range("I" & Target.Row).Value
   End If
    Application.EnableEvents = True
 Exit Sub
'error handler
ErrHnd:
 Err.Clear
'reenable events
 Application.EnableEvents = True
End Sub

Lejeye ap ka MACRO to ban gya, Is main ap dekh saktay hain ke H4:H20 tk ap ke stock ke cells hain... OnChange honay ki event ki waja se jesay hi ap H4 se le kr H20 cells main koe bhi value enter krain gay wo us ke sath walay "I" column se subtract ho gi aur result wapis H column ke usi particular cell main aa jay ga.

Ab simple is ko EXCEL main embed krna hai..us ke leye follow these steps

1) Copy all code.
2) Excel ki bottom main jo SHEET bar hoti hai, us main se apni sheet name pr right click krain
3) Click on VIEW CODE
4) Visual Basic Editor open ho ga, us ke body main yeh code paste kr dein
5) Close Editor

Ap ki better understanding keleye jo main ne explain kya hai us ki screen shots attach keye hain aur excel file bhi attach ki hai

Regards,
Atif Raza

**alim khan** · 22nd July 2011, 01:08 AM

AtifRaza said:

Brother CELL se formula's copy ho gatay hain MACROS nahe. Main ap ko is MACRO ko configure krna batata hun....

For Example "H" Column Stock hai, "I" Column Sale ka hai. H4 wo cell hai jahan se main ne stock ki value dalni start krni hai aur H20 cell tk stock ka data ja sakta hai. Is situation main ap ka MACRO yeh ho ga..

Code:

Private Sub Worksheet_Change(ByVal Target As Range)

  If Not Intersect(Range(Target.Address), Range("H4:H20")) Is Nothing Then

     Application.EnableEvents = False

       Range("H" & Target.Row).Value = Range("H" & Target.Row).Value _
         - Range("I" & Target.Row).Value
   End If
    Application.EnableEvents = True
 Exit Sub
'error handler
ErrHnd:
 Err.Clear
'reenable events
 Application.EnableEvents = True
End Sub

Lejeye ap ka MACRO to ban gya, Is main ap dekh saktay hain ke H4:H20 tk ap ke stock ke cells hain... OnChange honay ki event ki waja se jesay hi ap H4 se le kr H20 cells main koe bhi value enter krain gay wo us ke sath walay "I" column se subtract ho gi aur result wapis H column ke usi particular cell main aa jay ga.

Ab simple is ko EXCEL main embed krna hai..us ke leye follow these steps

1) Copy all code.
2) Excel ki bottom main jo SHEET bar hoti hai, us main se apni sheet name pr right click krain
3) Click on VIEW CODE
4) Visual Basic Editor open ho ga, us ke body main yeh code paste kr dein
5) Close Editor

Ap ki better understanding keleye jo main ne explain kya hai us ki screen shots attach keye hain aur excel file bhi attach ki hai

Regards,
Atif Raza

bhaiyon mai shayad aap logon ko samjha nahi pa raha hun.mere pass 120 pcs stock hai usmein se 1 tarikh ko 10 pcs ka sale huwa to bache 110 dusre din 25 pcs sale huwe baki bache 85.yeh silsila chalta rahega.stock ke colume mein ek hi din entry hogi jab ke sale rozana hota hai.mai chahta hun ke sale ki entry karne per stock me se minus ho jae.lekin aap ki file mein stock ki entry karne per sale minus ho raha hai.is se bhi kam chalega lekin is mein sale aur stock ki rozana entry karni padegi.