The attached workbook contains a macro (CombineWorksheets) that may do what you want. If you have any questions let me know. Tom
On Wed, Dec 24, 2008 at 8:28 AM, 2008ra...@gmail.com <2008ra...@gmail.com>wrote: > > hi, > > i have 5 sheets and columns A and B have same title's data, > for example > > column A have Name and Column B have Birthday, > but i have a lot of sheets and that data not be long and i can put all > data in a sheet.Can i do that easly with menu of excel? > > > > > > --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
CombineWorksheets.xls
Description: MS-Excel spreadsheet