Re: $$Excel-Macros$$ Auto Filter using Macro or Formula

2010-01-31 Thread San Pat
Hi Dilip, Thanks for your help. But when I tried to use pivot table for my original file, it is not working. Because of its limitation. Regards, Sandip On Sat, Jan 30, 2010 at 11:09 AM, Dilip Pandey dilipan...@gmail.com wrote: Dear Sandip, The format which you desire can be obtained by a

Re: $$Excel-Macros$$ Auto Filter using Macro or Formula

2010-01-31 Thread Dilip Pandey
Dear Sandip, Please share your file. If the size is huge, kindly zip it before sending. Thanks. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B Com(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On 1/31/10, San Pat myitems2...@gmail.com

Re: $$Excel-Macros$$ Auto Filter using Macro or Formula

2010-01-29 Thread ashish koul
Hi check the attachment On Fri, Jan 29, 2010 at 8:43 AM, Sandip Patel myitems2...@gmail.com wrote: Hi Friends, I have 10,000 rows excel sheet which has many column as well. I want to create a Macro or Formula which will filter the data by *“Type”*, in the separate sheet, from the file

$$Excel-Macros$$ Auto Filter using Macro or Formula

2010-01-28 Thread Sandip Patel
Hi Friends, I have 10,000 rows excel sheet which has many column as well. I want to create a Macro or Formula which will filter the data by Type , in the separate sheet, from the file ORIGINAL DATA which is stored on the shared drive. Please see the attached file. Regards, Sandip --