Forum Discussion
tdarenkov
Mar 15, 2023Copper Contributor
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...
tdarenkov
Mar 16, 2023Copper Contributor
Apologies. Before trying again - is the "zeta" symbol in your formula above just a placeholder for any letter? Thanks!
JosWoolley
Mar 16, 2023Iron Contributor
You can rename it to whatever you like if you wish.
- tdarenkovMar 17, 2023Copper ContributorHi, thanks again! Interestingly enough, it does not want to work if there's a lot of rows and a lot of references. I'm trying to figure out a way to get you a demo worksheet given the sensitivity.