Re: $$Excel-Macros$$ Assistance required

2011-07-03 Thread Venkatesan c
Hi Vikas, Look the Below Link http://excelvbatutor.com/vba_tutorial.html *Best Regards,* *Venkat* * * On Sun, Jul 3, 2011 at 3:39 PM, vikas verma wrote: > > Hi All, > > I am good with excel 2007 now I want to learn VBA coding in order to create > automation tool. Please suggest some ideas

RE: $$Excel-Macros$$ Assistance required

2011-07-03 Thread Rajan_Verma
25 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Assistance required try these video tutorials and websites http://akoul.wordpress.com/2011/05/27/excel-blogs-and-websites-learn-excel-o nline/ http://akoul.wordpress.com/2011/05/28/excel-video-tutorials/ On Su

Re: $$Excel-Macros$$ Assistance required

2011-07-03 Thread ashish koul
try these video tutorials and websites http://akoul.wordpress.com/2011/05/27/excel-blogs-and-websites-learn-excel-online/ http://akoul.wordpress.com/2011/05/28/excel-video-tutorials/ On Sun, Jul 3, 2011 at 3:39 PM, vikas verma wrote: > > Hi All, > > I am good with excel 2007 now I want to lear

$$Excel-Macros$$ Assistance required

2011-07-03 Thread vikas verma
Hi All, I am good with excel 2007 now I want to learn VBA coding in order to create automation tool. Please suggest some ideas. Thanks & Regards, Vikas Verma Bank of America delhi.ve...@gmail.com 337199 -- --

Re: $$Excel-Macros$$ Assistance Required

2010-08-11 Thread Prathap
Thanks dude. It works. Best Regards, PRATHAP D M +91 9899-370-328 On 9 August 2010 19:26, Bruno Bruno wrote: > My friend Prathap, > > Yes, there is. I did it in the Sample I am returning to you, but I would > strongly recommend other simpler ways to do it. > > The point is that up to Excel-0

Re: $$Excel-Macros$$ Assistance Required

2010-08-09 Thread Bruno Bruno
My friend Prathap, Yes, there is. I did it in the Sample I am returning to you, but I would strongly recommend other simpler ways to do it. The point is that up to Excel-07, microsoft has not implemented any default functions that deals with cells background colors (if I am wrong, somebody tells

$$Excel-Macros$$ Assistance Required

2010-08-08 Thread Prathap
Dear Experts, In the attached excel sheet i have employees attendance details for the entire month (Leaves - Violet, On Duty - Yellow, Present - Green Etc) with different color fills. I need the count of leaves, On duty, Etc for each employee. Is there is any way to count color wise, for each emp

Re: $$Excel-Macros$$ Assistance required

2010-04-05 Thread paulwillekens
ok, Prathap, let's start with the following macro: months without sales but with stock increase will get colored... is this what you want: highlight it? greetings Paul Willekens '=== Sub StockAnalysis() Dim lDone Dim nCol Dim

Re: $$Excel-Macros$$ Assistance required

2010-04-04 Thread Prathap
Dear Paul, The attached file has monthwise stock level for various products. I need to identify the cases where excess purchase (Stock received) without any consumption (stock Dispatched) in successive months. Eg: A Material having opening stock of 100 units in August. Stock dispatched in Septem

Re: $$Excel-Macros$$ Assistance required

2010-04-03 Thread paulwillekens
Hi Prathap, Tell us what you want for your analysis... In order to automate, we need to know what has to be automated... Till then, kind regards, Paul Willekens -- -- Some important links for excel users: 1. Follo

Re: $$Excel-Macros$$ Assistance required

2010-04-02 Thread Prathap
Hi All, I`m doing an anlysis for a stock where i need to identify the excess stock purchased despite availability of stock (stock lying without any consumption) in the sucessive months. Attached is the sample file (actual file line items are more 1 lac). Please help me out on the same. Thanks &

$$Excel-Macros$$ Assistance required

2010-04-02 Thread Prathap
Hi All, I`m doing an anlysis for a stock where i need to identify the excess stock purchased despite availability of stock (stock lying without any consumption) in the sucessive months. Attached is the sample file (actual file line items are more 1 lac). Please help me out on the same. Thanks &