Hi Ujjwal, Yes, you were able to make us understand. and the problem is Macro recorder is not enough intelligent to create loops for us. Now to better understand the problem, please post what you've recorded through macro.
For more tips, tricks, downloads and problem solutions: visit --> http://www.excelitems.com ------------------------------------------------------------------------ Regards *Ashish **Jain* Analyst, CSC Microsoft Certified Application (Excel) Specialist Excel and VBA Trainer Author -> www.excelitems.com +91-9999-40-48-43 ------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------- On Apr 19, 12:34 am, Ujjwal Jha <[email protected]> wrote: > Dear All, > > I have a query. I am working on pivot table wherein the tabe has few values > in column A. Now if i record a macro where I select the first item after > giving it a filter. Copy the details of first item into a new excel sheet. > Then save the macro. Next time when i run the macro it will only take only > the first option. > > Is there any way wherein when i run a macro it will open a new sheet for > every option in column A. > > I hope i was able to make u understand. > > -- > > Regards > Ujjwal Jha --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to [email protected] If you find any spam message in the group, please send an email to: Ayush Jain @ [email protected] or Ashish Jain @ [email protected] ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
