Re: $$Excel-Macros$$ Pivot table - Pivot tabel row Range

2011-04-04 Thread rakesh kumar
Could you tell me what have you done ??? On Sun, Apr 3, 2011 at 8:42 PM, Jaideep Panchal jai.ca...@gmail.com wrote: if it helps... -- Rakesh kumar khowal +91 9868532105 -- -- Some important links for excel

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - March 2011

2011-04-04 Thread mrinal saha
Ashish, You are doing such a tremendous job...Keep going Bro. regards, Mrinal On Sat, Apr 2, 2011 at 6:54 PM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Ashish Koul has been selected as 'Most Helpful Member' for the month of March'11 He has posted 48 posts in March 2011 and

Re: $$Excel-Macros$$ Excel help

2011-04-04 Thread STDEV(i)
i think mr. bhanu needs 000999 tobe 999 not 00999 On Mon, Apr 4, 2011 at 11:45 AM, §»VIPER«§ viper@gmail.com wrote: if your data in a1 type the below formula on anywhere in the same worksheet =IF(AND(ISTEXT(A1),LEFT(A1,1)=0),RIGHT(A1,LEN(A1)-1),A1) -- *Thanks Regards Thamu *

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - March 2011

2011-04-04 Thread Raghunandan
Gr8 goin On Mon, Apr 4, 2011 at 10:25 AM, mrinal saha mris...@gmail.com wrote: Ashish, You are doing such a tremendous job...Keep going Bro. regards, Mrinal On Sat, Apr 2, 2011 at 6:54 PM, Ayush Jain jainayus...@gmail.comwrote: Hello Everyone, Ashish Koul has been selected as

$$Excel-Macros$$ - Pivot table .Calculation = xlPercentOfColumn

2011-04-04 Thread rakesh kumar
Hi Members, Could you tell me where I should put the .Calculation = xlPercentOfColumn .NumberFormat = 0.00% to get desired results 'Define fields in PivotTable With PT ' Reference to Exisiting Pivot Table With .PivotFields(HHSizeGroup) .Orientation = xlRowField

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - March 2011

2011-04-04 Thread ashish koul
thank you everyone On Mon, Apr 4, 2011 at 5:01 PM, Raghunandan raghunandan...@gmail.comwrote: Gr8 goin On Mon, Apr 4, 2011 at 10:25 AM, mrinal saha mris...@gmail.com wrote: Ashish, You are doing such a tremendous job...Keep going Bro. regards, Mrinal On Sat, Apr 2, 2011 at 6:54

Re: $$Excel-Macros$$ Fwd: A sheet which will capture time along with name of Agents along with work assign for them.

2011-04-04 Thread Born to Win
thank u so much ranjan u have provide me solution exactly what i wanted heartiest thanks to u. Thanks, Prabhat On Mon, Apr 4, 2011 at 7:42 AM, rajan verma rajanverma1...@gmail.comwrote: Hi Prabhat, is it what you want.. find the attahced File Rajan On Sun, Apr 3, 2011 at 6:32 PM, Born to

Re: $$Excel-Macros$$ How to send mail with excel

2011-04-04 Thread santosh subudhi
Hi, http://www.rondebruin.nl/sendmail.htm http://msdn.microsoft.com/en-us/library/aa203718(office.11).aspx http://msdn.microsoft.com/en-us/library/aa203718(office.11).aspx#odc_thesendmail20utility Try the other links with other options available in the sites Regards Santosh On Wed, Mar 30,