stock mein se sale (sheet 1) atomatic minus ho jaye koi formula batain.
stock mein se sale (sheet 1) atomatic minus ho jaye koi formula batain.
ye check karain
farmula ye hai
=MIN(Sheet1!G7)
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
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,
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,
MS TELECOMMUNICATION SYSTEMS
BSCS HONORS
CCNA & MCP CERTIFIED
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..
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.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
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.
Bookmarks