$$Excel-Macros$$ Re: VBA to retrieve stock quotes from web

2009-08-05 Thread Jaspal Rehal
check this page... may be it could be any use for you http://www.ozgrid.com/forum/showthread.php?t=98321 Rg On Wed, Aug 5, 2009 at 12:19 AM, peace wrote: > > I need to retrieve stock information from a web site.   (It can be any > site that provides such information - the site is not important)

$$Excel-Macros$$ Re: Add multiple comments

2009-08-04 Thread Jaspal Rehal
thnx for prompt reply PFA an example of what I am looking for ... Rg On Tue, Aug 4, 2009 at 9:42 PM, Norman May wrote: > I'm not sure if this is what you want... > Example: > > ="The amount in cell A1 is "&A1&" and this will change daily." > >

$$Excel-Macros$$ Add multiple comments

2009-08-04 Thread Jaspal Rehal
Hi, I have to delete so many cell entries in my daily job and input those cell entries in the comments with some text. Any shortcut for the same would be helpful ... Rg --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: counting of diffrent cell values of same name or Numbers in nos

2009-08-04 Thread Jaspal Rehal
Try : COUNTIF formula Rg On Tue, Aug 4, 2009 at 6:14 PM, shivashankar katageri wrote: > Dear all, > > any body help me to sort out the with attached sheet > -- > Thanks & Regards > > Shivashankar.C.Katageri. > > > > > --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Re : Retaining date format while concatenating

2009-07-27 Thread Jaspal Rehal
Use the following formula =CONCATENATE(A1," ",TEXT(A2,"mm-dd-")) where A1 = Today is and A2 = date Rg On Mon, Jul 27, 2009 at 8:38 PM, Radhe Sham L wrote: > Hi Group > > This is a query regarding the date format retention in concatenate > > What happens is while concatenating some text wit