RE: $$Excel-Macros$$ Re: Need macro to split the files

2011-09-01 Thread Sudhir Kumar
-Macros$$ Re: Need macro to split the files I have also created thousands of functions, and PivotTables Good :) you're asking or you're selling web site? I'm am sharing ;) As Excel MVP, I have to share my knowledge for free on the web. So when a question is in relation with one of the page of my

Re: $$Excel-Macros$$ Re: Need macro to split the files

2011-08-31 Thread Frederic LE GUEN - MVP Excel
I have also created thousands of functions, and PivotTables Good :) you're asking or you're selling web site? I'm am sharing ;) As Excel MVP, I have to share my knowledge for free on the web. So when a question is in relation with one of the page of my website, I post the related page. --

Re: $$Excel-Macros$$ Re: Need macro to split the files

2011-08-31 Thread ChilExcel
ok thx , I understand 2011/8/31 Frederic LE GUEN - MVP Excel fleg...@gmail.com I have also created thousands of functions, and PivotTables Good :) you're asking or you're selling web site? I'm am sharing ;) As Excel MVP, I have to share my knowledge for free on the web. So when a

$$Excel-Macros$$ Re: Need macro to split the files

2011-08-30 Thread Frederic LE GUEN - MVP Excel
Why don't you use a pivot table with the table option to split your document by Division and Regional lead ? On 30 août, 06:52, anu gomathi anugomathi.d...@gmail.com wrote: Hi Experts, I am very new to this forum. Attached the details report the out put file. I need a macro to split the

Re: $$Excel-Macros$$ Re: Need macro to split the files

2011-08-30 Thread anu gomathi
Hi, Can u pls explain me the steps. Any way i need the summary in the detail sheet. Regards Anu On Tue, Aug 30, 2011 at 2:52 PM, Frederic LE GUEN - MVP Excel fleg...@gmail.com wrote: Why don't you use a pivot table with the table option to split your document by Division and Regional lead ?

Re: $$Excel-Macros$$ Re: Need macro to split the files

2011-08-30 Thread ChilExcel
Please attach file 2011/8/30 anu gomathi anugomathi.d...@gmail.com Hi, Can u pls explain me the steps. Any way i need the summary in the detail sheet. Regards Anu On Tue, Aug 30, 2011 at 2:52 PM, Frederic LE GUEN - MVP Excel fleg...@gmail.com wrote: Why don't you use a pivot

$$Excel-Macros$$ Re: Need macro to split the files

2011-08-30 Thread Frederic LE GUEN - MVP Excel
Hi I have written today a page about the way to create a worksheet function of a criteria http://www.excel-exercice.com/en/2074/creation-of-worksheets-by-criteria I'm sure that this tip will help you ;) On 30 août, 06:52, anu gomathi anugomathi.d...@gmail.com wrote: Hi Experts, I am very new

Re: $$Excel-Macros$$ Re: Need macro to split the files

2011-08-30 Thread ChilExcel
I have also created thousands of functions, and PivotTables you're asking or you're selling web site? 2011/8/30 Frederic LE GUEN - MVP Excel fleg...@gmail.com Hi I have written today a page about the way to create a worksheet function of a criteria