Forum Discussion
VSTACK, INDIRECT, and BYROW to pull in data from many sheets referencing a range of cell addresses
(update - attached file) Hi all! I have a unique problem which is a result of having to create a large "output" range from multiple sheets. I'm building a large "demo data" bank, but the res...
VSTACK accepts 3D references. You could use:
=VSTACK(TOROW(column_names),data1:data3!B4:E13)- Thanks, but the issue is that there are different amounts of data in each sheet - so "E13" might be "E3000". I guess I could filter it thought?
- Yes, stack and filter to clean up the stack. I recommend avoiding INDIRECT, if possible, because of its volatility.
