Forum Discussion
Re: Help with consolidation
There are 10 sheets in your workbook
- Which one contains the data you want to consolidate?
- Any pref. between a Power Pivot or Power Query solution?
4 Replies
- Whatever is the simplest to learn, haha. And Sheet 3, Columns B, C, D & E to the last row of 260. Sorry, I actually sent you the wrong sheet I had a less messy one. Thank you so much for your help!
Whatever is the simplest to learn
Just thought about an easier option that appears to work and doesn't require any learning. Wonder why I didn't think about it earlier...
- Formatted Sheet3 as Table (named Table1)
- Renamed Sheet3 as Data (for clarity)
See sheet Consolidation
Moving forward: when you add/delete/modify data in Table1, right-click somewhere in table Consolidation > Refresh
