I need to create a consolidate range consisting of ranges spread across multiple worksheets in Excel 2007. What I wish I could do is to use the VBA UNION function in a cell formula, but that doesn't seem to be an option.
I can handle VBA if necessary, but there's no telling if someone who would have to maintain this in the future would be able to.
My ultimate goal is to run functions such as MAX, MIN, AVERAGE, etc across the consolidated range.
Any help out there?