Re: $$Excel-Macros$$ Office stock

Won’t a simple vlookup using the false parameter work..?? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Smitha S R Sent: Wednesday, May 09, 2012 8:43 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Office stock Hi PFA the stock statement where I

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

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 If End

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

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 talk2mar...@gmail.com wrote: Hi, Try below codes, Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count 1 Or

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

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 sperdwo...@gmail.com wrote: Hi, Below mentioned code is not working. Even if I select Opening

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

Thanks alot On Wed, May 9, 2012 at 3:25 PM, Maries talk2mar...@gmail.com 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

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

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 Ansari

$$Excel-Macros$$ Office stock

Hi PFA the stock statement where I need help in the Dashboard. If I select, the item I need the relevant closing stock in the next cell. My formula is not working. Please help. Thanks Smitha -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles.

Re: $$Excel-Macros$$ Office stock

Hi Smitha, Please try it.. =INDEX('Stock n cnsmpn-May 2012'!$E:$E,MATCH(Dashboard!C2,'Stock n cnsmpn-May 2012'!$A:$A,0)) and see attached sheet. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, May 10, 2012 at 7:13 AM, Smitha S R

Re: $$Excel-Macros$$ Office stock

Hi Smitha, Please try this too, its good working. below!! * =IF(R[-4]C=,,VLOOKUP(R[-4]C,'Stock n cnsmpn-May 2012'!C[-2]:C[2],5,0)) * Thanks Regards,* * *Deba Ranjan P*** On Thu, May 10, 2012 at 7:54 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Hi Smitha, Please try it..

$$Excel-Macros$$ office stock-help

Hi, PFA the attachment. Office stock consumption statement is attached where I need the help on solving the explained below: .. I need the closing stock of the relevant items from the other work sheet 'closing st n Utlzn-Apr 2012' in the column 'Qty' of the work sheet 'May 2012' if the

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

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 sperdwo...@gmail.com wrote: Hi, PFA the attachment. Office stock consumption statement is attached where I need the help

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

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 talk2mar...@gmail.com wrote: HI, Try Vlookup for bring closing

Re: $$Excel-Macros$$ Office stock consumption - formula needed to solve the attached.

Hi Smitha, Please share your workbook with group. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Sun, May 6, 2012 at 2:38 PM, Smitha S R sperdwo...@gmail.com wrote: On Sun, May 6, 2012 at 2:37 PM, Smitha S R sperdwo...@gmail.com wrote: Hi,

$$Excel-Macros$$ Office stock consumption - formula needed to solve the attached.

On Sun, May 6, 2012 at 2:37 PM, Smitha S R sperdwo...@gmail.com wrote: Hi, Any one please help: PFA the attachment of office stock. One sheet shows the closing stock of stationery items. In the second sheet, if I select particulars as Opening stock I need toe get the closing

Re: $$Excel-Macros$$ Office stock consumption - formula needed to solve the attached.

HI Please try below one =IFERROR(VLOOKUP(D2,'Utilization and Closing stock'!A2:C19,3,FALSE), ) On Sun, May 6, 2012 at 2:38 PM, Smitha S R sperdwo...@gmail.com wrote: On Sun, May 6, 2012 at 2:37 PM, Smitha S R sperdwo...@gmail.com wrote: Hi, Any one please help: PFA the