Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory

2014-12-29 Thread Vaibhav Joshi
gt; >> + >> *I did not do this for you. God is here working through me for you.* >> >> On Tue, Dec 23, 2014 at 9:18 PM, C.G.Kumar >> wrote: >> >>> May someone please look and advise macro to solve the puzzle. >>> >>> Thanks and Rega

Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory

2014-12-28 Thread C.G.Kumar
; >> May someone please look and advise macro to solve the puzzle. >> >> Thanks and Regards, >> C.G.Kumar >> >> -- Forwarded message ----- >> From: C.G.Kumar >> Date: Mon Dec 22 2014 at 7:09:55 PM >> Subject: Re: $$Excel-Macros$$ Re:

Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory

2014-12-23 Thread Vaibhav Joshi
t; C.G.Kumar > > -- Forwarded message - > From: C.G.Kumar > Date: Mon Dec 22 2014 at 7:09:55 PM > Subject: Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory > To: excel-macros@googlegroups.com > > > Macro is not providing desired result. > >

Fwd: $$Excel-Macros$$ Re: Macro for Ageing of Inventory

2014-12-23 Thread C.G.Kumar
May someone please look and advise macro to solve the puzzle. Thanks and Regards, C.G.Kumar -- Forwarded message - From: C.G.Kumar Date: Mon Dec 22 2014 at 7:09:55 PM Subject: Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory To: excel-macros@googlegroups.com Macro is not

Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory

2014-12-22 Thread C.G.Kumar
Macro is not providing desired result. Attached worksheet looks at total Purchase of Specific qty and provides ageing. But the need is to have ageing (& Value) of balance stock only. This mean in Solved worksheet of yours, total qty left in Cell "B5" is to be keyed in Manually and macro is expec

$$Excel-Macros$$ Re: Macro for Ageing of Inventory

2014-12-22 Thread Mandeep Baluja
Try this File hope it reach you expected Result. Regards, Mandeep Baluja LearningZmyPassion https://www.linkedin.com/profile/view?id=312532939 https://www.facebook.com/VBAEXCELSQL?ref=hl On Monday, December 22, 2014 9:44:49 AM UTC+5:30, kumar wrote: > > Hi, > > I have purchase data in a sprea

Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory

2014-12-22 Thread C.G.Kumar
Hi, At year end, we need to determine age of Items left in Inventory. For example, we are left with 2 pieces of Material Part No.357000 at year end, and need to determine age of these two quantities of material based on purchase. We go to purchase data and find most recent purchase. Recent Pur

Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory

2014-12-22 Thread C.G.Kumar
Please see attached file. Let me know if any additional info is required. On Mon, Dec 22, 2014 at 3:18 PM, Anil Gawli wrote: > Dear Rockernayal, > > Pls share a workbook with us. > > Regards, > Gawli Anil > > On Mon, Dec 22, 2014 at 3:15 PM, Mandeep Baluja > wrote: > > Please explain your Qu

Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory

2014-12-22 Thread Anil Gawli
Dear Rockernayal, Pls share a workbook with us. Regards, Gawli Anil On Mon, Dec 22, 2014 at 3:15 PM, Mandeep Baluja wrote: > Please explain your Query Again I an unable to understand it . Aeging can be > count but on what criteria whether on particular order no, material no , > document no. whe

$$Excel-Macros$$ Re: Macro for Ageing of Inventory

2014-12-22 Thread Mandeep Baluja
Please explain your Query Again I an unable to understand it . Aeging can be count but on what criteria whether on particular order no, material no , document no. where is availble qty column. On Monday, December 22, 2014 9:44:49 AM UTC+5:30, kumar wrote: > > Hi, > > I have purchase data in a