Jan 12 2019 10:50 AM
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?
yr help is much appreciated
Michael
Jan 12 2019 01:09 PM
You may create helper list with names of all your sheets and use it with INDIRECT to pickup your values.
Jan 13 2019 07:17 AM
Jan 13 2019 07:26 AM
SolutionThat looks like
with formula in B2
=INDIRECT("'"&A2&"'!N17")
(drag it down)
Jan 13 2019 07:26 AM
SolutionThat looks like
with formula in B2
=INDIRECT("'"&A2&"'!N17")
(drag it down)