•1 min read•from 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.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#google sheets
#cloud-based spreadsheet applications
#Excel alternatives
#financial modeling with spreadsheets
#vstack
#array
#A3#
#sheet
#Array 1
#Accounts - A
#Accounts - B
#Accounts - C
#parameter
#output
#formula