3D VStack Spill Array

[wsnyder]

Hi,

Using M365.
Is it possible to create 3D VStack with spill array?

I tried

=VSTACK(AMZN:WMT!A7#)

Where AMZN is my first sheet and WMT is my last sheet
All sheets in the sheets array contain a spill array at A7#

But I am getting a #REF! error.

Thanks,
-w

 

[Fluff]

When using a 3D reference, the range must be exactly the same on each sheet & there is no guarantee that spill ranges will give that. Therefore it doesn't work.
You would need to stack each sheet individually.