This is my first time posting here, though I've gotten plenty of answers from these forums in the past.
I am using the data consolidation feature in Excel 2013. Because the two sheets I'm consolidating might have different sized ranges each time, I want to capture the used range for each sheet...