newbrownshoe
New Member
- Joined
- Mar 12, 2013
- Messages
- 1
Hello, and thanks for providing this forum. I use Excel 2010. I do not understand VBA.
I am looking at the Excel Aggregate command video on You Tube at Excel 2010 Magic Trick 797: Check Items In List And Have Them Appear On New Sheet - AGGREGATE - YouTube (Excel Trick 797).
I want to gather results from 12 worksheets, not just one (as shown in the video). Then consolidate the checked items from across 12 sheets onto one master sheet.
The lists on each of the 12 worksheets are different lengths, varying from 25 rows to 210 rows. Depending on the user, some sheets may not have any checked items at all.
The video explains how to source the answer from one sheet. I am unsure how to expand the formula to 12 sheets.
Any help would be greatly appreciated.
I am looking at the Excel Aggregate command video on You Tube at Excel 2010 Magic Trick 797: Check Items In List And Have Them Appear On New Sheet - AGGREGATE - YouTube (Excel Trick 797).
I want to gather results from 12 worksheets, not just one (as shown in the video). Then consolidate the checked items from across 12 sheets onto one master sheet.
The lists on each of the 12 worksheets are different lengths, varying from 25 rows to 210 rows. Depending on the user, some sheets may not have any checked items at all.
The video explains how to source the answer from one sheet. I am unsure how to expand the formula to 12 sheets.
Any help would be greatly appreciated.
