Forum Discussion
Solved
create a list
Hi Experts, i have an Excel file with 35 identical structured spreadsheets and i need a list which contains cell a2 and n17 from each spreadsheet displayed in a list. which function do I need to use?...
That looks like
with formula in B2
=INDIRECT("'"&A2&"'!N17")(drag it down)
You may create helper list with names of all your sheets and use it with INDIRECT to pickup your values.