# Excel Help needed **URL:** \ **Category:** Factual Questions\ **Created:** [March 28, 2014, 3:22am UTC](https://boards.straightdope.com/t/excel-help-needed/684735 "2014-03-28T03:22:30Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![MannyL](https://avatars.discourse-cdn.com/v4/letter/m/ba8739/32.png) [@MannyL](https://boards.straightdope.com/u/MannyL)\ **Post date:** [March 28, 2014, 3:22am UTC](https://boards.straightdope.com/t/excel-help-needed/684735/1 "2014-03-28T03:22:30Z")
I’m not sure if this can be done, but at work I’m thought of a computer guru and I hate to dissuade them of that image. I have 52 files dated 2014 Week 1 through 2014 week 52. The files have five tabs to correspond to the days of the week. Each day is broken down into 16 segments and 16 categories. I need to build a macro that will query the 52 files to create another spreadsheet to show the average # of calls in each segment and category over the year. Is this even possible? ---
**Author:** ![Reply](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/reply/32/15952_2.png) [@Reply](https://boards.straightdope.com/u/Reply)\ **Post date:** [March 28, 2014, 3:25am UTC](https://boards.straightdope.com/t/excel-help-needed/684735/2 "2014-03-28T03:25:31Z")
Yes, it’s possible, but maybe look into PivotTables instead. They exist for situations like this (summarizing information into groups). ---
**Author:** ![Reply](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/reply/32/15952_2.png) [@Reply](https://boards.straightdope.com/u/Reply)\ **Post date:** [March 28, 2014, 3:42am UTC](https://boards.straightdope.com/t/excel-help-needed/684735/3 "2014-03-28T03:42:29Z")
Sorry, I missed the part about FILES. I thought they were all in one giant workbook. Try something like this (uses both a macro and pivottables): > **[Create Pivot Table or Excel Table from Multiple Files – Contextures Blog](https://contexturesblog.com/archives/2013/09/19/create-pivot-table-or-excel-table-from-multiple-files/)** ---
**Author:** ![MannyL](https://avatars.discourse-cdn.com/v4/letter/m/ba8739/32.png) [@MannyL](https://boards.straightdope.com/u/MannyL)\ **Post date:** [March 28, 2014, 3:51am UTC](https://boards.straightdope.com/t/excel-help-needed/684735/4 "2014-03-28T03:51:00Z")
Reply thanks for the Reply. I will look into the Pivot Table when I am back at work tomorrow. Spreadsheets are normally out of my role at work but I try not to say no to the office manager when something is asked of me.