Hello, Do you mean that you want to collect the data on all 5 sheets and add it to a 6th sheet and then save the workbook with all 6 sheets? Or do you need to take the data from the 5 sheets and put it on one sheet, then saving a new workbook with only one sheet? --- On Tue, 11/30/10, Manjunath C <cmanjunathchen...@gmail.com> wrote:
From: Manjunath C <cmanjunathchen...@gmail.com> Subject: $$Excel-Macros$$ Need help on excel sheet To: excel-macros@googlegroups.com Date: Tuesday, November 30, 2010, 4:12 AM Hi All, Can anyone help me, I have data in 5 tabs, now i need to make it in seperate excel sheet and paste it local desktop. Any macros available - appreciate your help in advance. Thanks Manjunath -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts