check the article below, this should give you a start for what your are looking to do http://funwithexcel.blogspot.com/2009/05/macro-to-copy-worksheets-from-master.html
In this I have shown how to copy the whole excel sheet, you got to tweak a bit, get the active cell and paste all sheets one by one in same worksheet. On Fri, May 22, 2009 at 12:46 AM, shannu shannu <shannur...@yahoo.com>wrote: > Hi All > > I have many sheets and I want to copy in one main excel sheet > but I want to copy ne after the other exce sheet's data, it shd be like a > ladder or a staircase. > > Sheets like A1, B1, C1 etc and one man sheet called "JAN". > I want to copy all the visible rows which are present in A1, B1,C1 and > paste it in Jan excel one after the other. > > Regards, > Shahina > > > > > > -- http://funwithexcel.blogspot.com/ --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
