i think my question tab is missing do you want to show the blank records if the data of the employ is missing in day
also how many total employees you have On Tue, Apr 5, 2011 at 2:03 AM, John A. Smith <johnasmit...@gmail.com>wrote: > I receive an Excel file download everyday (see <Daily Workload Report > 032911.xls>, <Daily Workload Report 040211.xls> and <Daily Workload Report > 040311.xls>. I need to summarize them into one database and be able to > report specific trends and situations. Please see the attached file > <Daily Workload Report Summary.xls>. It has three tabs: Data Summary (as > it would look if all reports were combined), My Questions (tab) is where I > need specific help. I need a macro to consolidate the files and formula > help to extract the data. > > Thank you for your continuing help teaching the power of Excel. > > John > > -- > > ---------------------------------------------------------------------------------- > 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 > -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com <http://akoul.blogspot.com/> *akoul*.wordpress.com <http://akoul.wordpress.com/> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> P Before printing, think about the environment. -- ---------------------------------------------------------------------------------- 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
