if you need separate sheet or day must use "consolidate" on an individual basis sheet or day ....should not selecting all the sheets
chilexcel 2011/3/3 ChilExcel <chilexcel...@gmail.com> > hi > > you must use "consolidate" > look at this link > > > http://www.techrepublic.com/article/create-a-summary-report-in-excel-with-data-consolidation/5710152 > > any questions, talk > > chilexcel > > > > > > > > 2011/3/3 sudarshan rampe <sidhu...@gmail.com> > > hi friends herewith i am attaching an excel sheet with this mail in which >> i require your help. >> i have the data in three different sheets of diffrernt periods (24, 28, 32 >> ) >> i want to club the data of all the 3 sheets in the last sheet named Total >> Data by taking the bird number in the first column. >> the same bird number will be there in the 28 and 32 also. >> thank you in anticipation >> sudarshan >> >> -- >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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/discussexcel >> > > > > -- > Visita ; http://sites.google.com/site/chilexcel/Home > Visita ; http://www.youtube.com/user/timextag41 > > -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- ---------------------------------------------------------------------------------- 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/discussexcel