$$Excel-Macros$$ Re: HEY NEED HELP

2009-09-21 Thread Sonia Singla
Hi Ashish do you want a macro for this because this you can do by changing the format. Sonia On Mon, Sep 21, 2009 at 12:35 PM, ashish koul wrote: >8/3/2009 8/3/2009 8/3/2009 8/4/2009 8/4/2009 8/4/2009 5/8/2009 5/8/2009 > 5/8/2009 5/8/2009 5/8/2009 5/8/2009 > THEY ARE IN DD MM > > I W

$$Excel-Macros$$ Re: HEY NEED HELP

2009-09-21 Thread Sonia Singla
Hi ashish to do this first u select the data then click right button and go to format cells. Then select custom in number tab. there type "dd/mm/" Sonia On Mon, Sep 21, 2009 at 6:19 PM, Sonia Singla wrote: > Hi Ashish > > do you want a macro for this because this you

$$Excel-Macros$$ Need to color the duplicates

2009-09-21 Thread Sonia Singla
Hi I have the data in an array say in nXm. I want to make a macro color the cells with the same color having the same next. for example cells having 2 should have color red, cells having 5 should have color blue etc. Thanks Sonia --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Re: Unique record retrieval

2009-10-02 Thread Sonia Singla
Hi Dilip Its really great yar Sonia On Wed, Sep 30, 2009 at 5:15 PM, Dilip Pandey wrote: > Hi Aligah, > > I have attached an image, which has the example of using auto-filter to > solve your query. Thanks > > -- > DILIP KUMAR PANDEY > MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan

$$Excel-Macros$$ Re: Excel Macro

2009-01-07 Thread Sonia Singla
Hi Tom Even I also wants to learn Excel Macro in order to automate all of my process. So do you have more practical examples to understand macro easily. Thanks and Regard Sonia Singhal On Tue, Jan 6, 2009 at 1:03 AM, Kamal Gulati wrote: > Dear Mr. Tom, > > Even I also required some more exam