Re: $$Excel-Macros$$ office stock-help

2012-05-09 Thread NOORAIN ANSARI
Hi Smitha, Maries solution is nice.. Apart of this you can also use below formula without using Macros. Put formula in Range("E2") *=IF($B2="Opening Stock",INDEX('Closing St n Utlzn-Apr 2012'!$C$2:$C$65,MATCH(D2,'Closing St n Utlzn-Apr 2012'!$A$2:$A$65,0)),"")* -- Thanks & regards, Noorain An

Re: $$Excel-Macros$$ office stock-help

2012-05-09 Thread Smitha S R
Thanks alot On Wed, May 9, 2012 at 3:25 PM, Maries wrote: > I think MACRO IS NOT ENABLED. When you open file, Security warning show > under Ribbon. Click options ==> Select Enable this content ==> Press ok. > > Try now... > > On Wed, May 9, 2012 at 11:57 AM, Smitha S R wrote: > >> Hi, >> >> Be

Re: $$Excel-Macros$$ office stock-help

2012-05-09 Thread Maries
I think MACRO IS NOT ENABLED. When you open file, Security warning show under Ribbon. Click options ==> Select Enable this content ==> Press ok. Try now... On Wed, May 9, 2012 at 11:57 AM, Smitha S R wrote: > Hi, > > Below mentioned code is not working. Even if I select Opening Stock, > Purchas

Re: $$Excel-Macros$$ office stock-help

2012-05-09 Thread Smitha S R
Hi, Below mentioned code is not working. Even if I select Opening Stock, Purchase or Issue option qty is same. On Wed, May 9, 2012 at 11:44 AM, Maries wrote: > Hi, > > Try below codes, > > Private Sub Worksheet_Change(ByVal Target As Range) > If Target.Cells.Count > 1 Or Target.Column <> 2 Then

Re: $$Excel-Macros$$ office stock-help

2012-05-08 Thread Maries
Hi, Try below codes, Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count > 1 Or Target.Column <> 2 Then Exit Sub If Target.Value = "Opening Stock" Then Target.Offset(0, 3) = "=VLOOKUP(RC[-1],'Closing St n Utlzn-Apr 2012'!R2C1:R65C3,3,FALSE)" Else Target.Offset(0, 3) = "" End

Re: $$Excel-Macros$$ office stock-help

2012-05-08 Thread Smitha S R
Hi, PFA the statement with the formula as mentioned in the below mail. But if the particulars is selected Purchase /Issue other than Opening Stock , the qty is not changing. Please help. On Wed, May 9, 2012 at 10:53 AM, Maries wrote: > HI, > > Try Vlookup for bring closing datas... > > =VLOOK

Re: $$Excel-Macros$$ office stock-help

2012-05-08 Thread Maries
HI, Try Vlookup for bring closing datas... =VLOOKUP(D2,'Closing St n Utlzn-Apr 2012'!$A$2:$C$65,3,FALSE) Regards, MARIES. On Tue, May 8, 2012 at 9:31 PM, Smitha S R wrote: > Hi, > > PFA the attachment. > > Office stock consumption statement is attached where I need the help on > solving the