I have data, by account and then department, for a few years. Each year is an entirely seperate report and I need to consolidate them all to one sheet so that I can do some sort subtotaling or pivot table that would give this data by department, then account, for each year.
Data sets look like tabs FY07 and FY08 in the attached sample file. The 'Summary' tab is what I'm after, so that I could subtotal or pivot.
Many thanks!
Bookmarks