Re: $$Excel-Macros$$ Re: Copy of Inventry control plan.xls

2013-01-06 Thread Lalit Mohan Pandey
Hi Harshad, Provided details is not according to the file you shared. Regards, Lalit Mohan On Monday, 7 January 2013 10:53:25 UTC+5:30, harshad shukla wrote: > > The parametr is vendor.i want vendorwise quantity detail of stock item and > item code is primary differentiating factor > On Jan 7,

Re: $$Excel-Macros$$ office stationery template

2013-01-06 Thread Lalit Mohan Pandey
Type *excel stationary inventory template* in google.com and find which suits you. Regards, Lalit Mohan On Monday, 7 January 2013 08:02:44 UTC+5:30, Smitha S R wrote: > > Hi, > Anyone please send me some good excel template to maintain the office > stationery items, their consumption, opening s

$$Excel-Macros$$ Re: Need a macro to copy cells based upon a values in other cell.

2013-01-06 Thread Lalit Mohan Pandey
Hi Dear, Paste this code in to your workbook module and run *FillwithSource procedure.* *Sub FillWithSource()* * * *Dim wksSht As Worksheet* *Dim rngRangeAs Range* *Dim rngCell As Range* *Dim rng

Re: $$Excel-Macros$$ Re: Copy of Inventry control plan.xls

2013-01-06 Thread harshad shukla
The parametr is vendor.i want vendorwise quantity detail of stock item and item code is primary differentiating factor On Jan 7, 2013 9:59 AM, "Lalit Mohan Pandey" wrote: > Hi Harshad, > > First of all this thread should be comes under you previous thread as you > are asking same thing in both th

Re: $$Excel-Macros$$ Re: Copy of Inventry control plan.xls

2013-01-06 Thread Lalit Mohan Pandey
Hi Harshad, First of all this thread should be comes under you previous thread as you are asking same thing in both thread https://groups.google.com/forum/#!topic/excel-macros/Y2PNmj1V-ZU%5B1-25-false%5D And second what is the parameter to differentiate two same values. Regards, Lalit Mohan O

Re: $$Excel-Macros$$ Re: Vlookup for two same values

2013-01-06 Thread harshad shukla
I primarily want inclusion of all values in vlookup. Even if there is repetition of two item codes.corresponding inventory should be displayed.ordinarily only first value is taken. On Jan 7, 2013 9:54 AM, "Lalit Mohan Pandey" wrote: > Hi Harshad, > > Could you please explain how can you defrencia

$$Excel-Macros$$ Re: Vlookup for two same values

2013-01-06 Thread Lalit Mohan Pandey
Hi Harshad, Could you please explain how can you defrenciate two same value like for which value i want data. Regards, Lalit Mohan On Friday, 4 January 2013 14:52:15 UTC+5:30, Prince wrote: > > Share your workbook. > > Regards > Prince > > On Friday, January 4, 2013 2:47:55 PM UTC+5:30, harshad

$$Excel-Macros$$ Re: Pivot from Multiple sheet

2013-01-06 Thread Prince
Hi Amit, May be this can be help full for you. http://office.microsoft.com/en-in/excel-help/consolidate-multiple-worksheets-into-one-pivottable-report-HA010226585.aspx http://blog.contextures.com/archives/2010/04/16/how-to-create-an-excel-pivot-table-from-multiple-sheets/ http://verticalhorizo

$$Excel-Macros$$ Re: Introduce Yourself !!

2013-01-06 Thread Prince
welcome narang regards prince On Sunday, January 6, 2013 10:17:08 PM UTC+5:30, VIKAS NARANG wrote: > > > > Hi everyone ! > > My name is Vikas Narang . I am a Finance Professional . Have done Master > in Finance 6 years ago and desire to know basics and advance features of > Excel . Also I will

Re: $$Excel-Macros$$ office stationery template

2013-01-06 Thread Smitha S R
Hi, Anyone please send me some good excel template to maintain the office stationery items, their consumption, opening stock , closing stock, and reports on monthly basis and daily basis On Sun, Jan 6, 2013 at 1:40 PM, Smitha S R wrote: > Hi, > Anyone please send me ome good excel template to m

$$Excel-Macros$$ Re: Introduce Yourself !!

2013-01-06 Thread VIKAS NARANG
Hi everyone ! My name is Vikas Narang . I am a Finance Professional . Have done Master in Finance 6 years ago and desire to know basics and advance features of Excel . Also I will like to contribute to the group if I come to know about any advance feature of Excel . Thanks Ayush ji for send

Re: $$Excel-Macros$$ Lookup and Replace

2013-01-06 Thread ravinder negi
here is the solution  On Thu, 1/3/13, Awal wrFrom: Awal Subject: $$Excel-Macros$$ Lookup and Replace To: excel-macros@googlegroups.com Date: Thursday, January 3, 2013, 8:47 AM Hello,I would like to wish y'all a Happy New year... I am still learning VBA and I really need help:I want to be able to

Re: $$Excel-Macros$$ office stationery template

2013-01-06 Thread Smitha S R
no attachment found On Sun, Jan 6, 2013 at 2:09 PM, wrote: > ** > Google.com > Sent from BlackBerry® on Airtel > -- > *From: * Smitha S R > *Sender: * excel-macros@googlegroups.com > *Date: *Sun, 6 Jan 2013 13:40:51 +0530 > *To: * > *ReplyTo: * excel-macros@googlegro

Re: $$Excel-Macros$$ office stationery template

2013-01-06 Thread mohan . pandey87
Google.com Sent from BlackBerry® on Airtel -Original Message- From: Smitha S R Sender: excel-macros@googlegroups.com Date: Sun, 6 Jan 2013 13:40:51 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ office stationery template Hi, Anyone please send me ome good ex

Re: $$Excel-Macros$$ office stationery template

2013-01-06 Thread Smitha S R
Hi, Anyone please send me ome good excel template to maintain the office stationery items, their consumption, opening stock , closing stock, and reports on monthly basis and daily basis On Sun, Jan 6, 2013 at 9:30 AM, Smitha S R wrote: > HI, > > Can anyone send some good excel template to mainta