No, I have different data (place wise) in 5 tabs, my expectation is that wile pasting the raw data in the first sheet , it should divide the data as per the region or place wise in the remaining sheet and that needs to be seperated in different individual sheet in my desktop or in a different file.
Thanks Manjunath On Tue, Nov 30, 2010 at 4:40 PM, Frank Linden <frankjlin...@yahoo.com>wrote: > 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 > -- ---------------------------------------------------------------------------------- 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