rjbinney
Active Member
- Joined
- Dec 20, 2010
- Messages
- 294
- Office Version
- 365
- Platform
- Windows
I feel like I knew how to do this once, but I'll be ****ed if I can find a worksheet where I pulled it off.
Essentially, I have a workbook where expenses are logged in monthly tabs (so May 2017 has a sheet listing each category and expense, June has its own, etc. etc.).
Now I'd like to write a report that shows "Sales Commissions" across every month. Every idea I have keeps coming back to using (poorly) INDIRECT functions and getting lots of errors.
I feel like there must be a smart way to consolidate? It's a pivot, but I think it turns a different direction than a Pivot Table!
Essentially, I have a workbook where expenses are logged in monthly tabs (so May 2017 has a sheet listing each category and expense, June has its own, etc. etc.).
Now I'd like to write a report that shows "Sales Commissions" across every month. Every idea I have keeps coming back to using (poorly) INDIRECT functions and getting lots of errors.
I feel like there must be a smart way to consolidate? It's a pivot, but I think it turns a different direction than a Pivot Table!