Re: $$Excel-Macros$$ Identifying Excel number format

2013-10-06 Thread Sandeep Chhajer
Dear De Premor, Sorry for the late reply. Your code is running perfectly. Thanks for the code. On 5 October 2013 18:22, De Premor wrote: > try this > > Sub xcv() > Dim Data As Range, Rng As Range > > Set Data = Range("A6") > > Set Data = Range(Data, Data.End(xlDown)).Offset(, 4)

Re: $$Excel-Macros$$ I want to show flag using conditional formatting

2013-10-06 Thread Waseem Saifi
thank you so much Ravinder. Regards, Waseem Saifi On Mon, Oct 7, 2013 at 10:25 AM, Ravinder wrote: > PFA > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Waseem Saifi > *Sent:* Saturday, October 05, 2013 10:02 AM > *To:* excel-macr

Re: $$Excel-Macros$$ Complicated Formula (automatic add back)

2013-10-06 Thread amar takale
Dear Ravinder Actually I want Previous balance Quantity of A ( 5 unit) in cell H23 to add this 5 Quantity in next cell F27 Same Name A means total Received Quantity+Previous balance Quantity of A (Answer is 2+5=7) like this next... Regards Amar On Sat, Oct 5, 2013 at 2:48 PM, Ravinder wro

$$Excel-Macros$$ Email Trigger ?

2013-10-06 Thread Bill Q
Hi, I am using Excel 2007 and have Gmail as my primary email account. I have a dynamic spreadsheet that monitors different stock prices that is refreshed ever "x" amount of minutes. I would like to have a small macro created so that when a certain cell is either <= to a certain price, will au

$$Excel-Macros$$ Re: I want to show flag using conditional formatting

2013-10-06 Thread Basole
Ok Waseem, my suggestion would be as an alternative. But really the flags icon sets conditional formatting are more defined. tks. Em sábado, 5 de outubro de 2013 01h31min52s UTC-3, Waseem Saifi escreveu: > > Hi Experts, > I want to show flag next to value's coulmn basis on criteria that if

$$Excel-Macros$$ US-IT RECRUITEMENT:TRAINING AND PLACEMENTS IN BANGALORE

2013-10-06 Thread Sahasra roy
-- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULE

RE: $$Excel-Macros$$ Re: Pie chart

2013-10-06 Thread joseph camill
Hi Ravi, Pie chart calculates the percentage by its inbuilt feature and is the whole pie is equal to 100%. I just want the first slice to be exactly in the centre to the right as I had ahown in my original example. Let me know if you need any further clarification. Thanks, Joseph On Oct 5, 2013

Re: $$Excel-Macros$$ Re: I want to show flag using conditional formatting

2013-10-06 Thread Waseem Saifi
Dear Basole, please see attachment. Regards, Waseem Saifi On Sun, Oct 6, 2013 at 12:20 PM, Waseem Saifi wrote: > thanx basole, > > But I want to show flag of icon sets from conditional formatting. > > Regards, > Waseem Saifi > > > On Sat, Oct 5, 2013 at 7:44 PM, Basole wrote: > >> Hi Waseem,

Re: $$Excel-Macros$$ I want to show flag using conditional formatting

2013-10-06 Thread Waseem Saifi
thank you so much vijay, it worked absolutely fine. Regards, Waseem Saifi On Sat, Oct 5, 2013 at 11:18 AM, Ravinder wrote: > pfa > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *P.VIJAYKUMAR > *Sent:* Saturday, October 05, 2013 10: