1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Vstacking indirects with an array

Hi,

I have an array that gives me the name of every sheet that fits a certain parameter (let’s call this Array 1). I want to use this array vstack array A3# for each sheet. To clarify every single one of the sheets in the Array 1 has an array A3#. Is this possible?

The output I’d like is: Vstack(‘Accounts - A’!A3#, ‘Accounts - B’!A3#, ‘Accounts - C’!A3#, etc.) based on Array 1 which currently spits out: Accounts - A, Accounts - B, Accounts - C, Accounts - D, etc.

submitted by /u/ziggyzigg95
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article