jassybun
Member
Hey guys! I have been looking at Kirill's workbook for using multiple workbooks in a pivot table...I am wondering if you guys know if it can handle my situation. In Kirill's file http://www.pivot-table.com/2010/08/30/pivot-table-from-data-in-multiple-workbooks/, the workbooks all have their data in "Sheet1"...however my data is set up a bit different.
I have a file for each week: "06292013" (there will be a new one for every week) ..within this file there are 5 workbooks...one for each day of the week...Monday, Tuesday, Wednesday, Thursday, Friday...in each of these days the first 3 tabs are BV, LV and GL. Each of these sheets have the same top row headers. In the end I need a separate workbook (similar to Kirills "Report" workbook) that has the data from the whole week for each area, BV, LV and GL that I can manipulate in a pivot table. There are additional worksheets in the workbook that are not going to be used, only the BV, LV and GL sheets need to be included.
Can anyone help me with adjusting this workbook for my situation.....I am not so great with arrays....
Thanks!
Jassybun
I have a file for each week: "06292013" (there will be a new one for every week) ..within this file there are 5 workbooks...one for each day of the week...Monday, Tuesday, Wednesday, Thursday, Friday...in each of these days the first 3 tabs are BV, LV and GL. Each of these sheets have the same top row headers. In the end I need a separate workbook (similar to Kirills "Report" workbook) that has the data from the whole week for each area, BV, LV and GL that I can manipulate in a pivot table. There are additional worksheets in the workbook that are not going to be used, only the BV, LV and GL sheets need to be included.
Can anyone help me with adjusting this workbook for my situation.....I am not so great with arrays....
Thanks!
Jassybun