Apr 14 2020 05:23 AM
I wont to us the value of a cell to point to a particular sheet in a data file. How can I do that?
Example:
In cell A2 I specify the name "Sheet2" as the sheet to be used. How can the formula "=SUM(xxxxxx!$A$1:$A$10)" arranged such that the content of cell A2 is placed on "xxxxx". I have to do this 500 times for all the data available, so a simple replace operation is too borring.
Apr 14 2020 06:56 AM
SolutionApr 15 2020 01:09 AM
Apr 15 2020 01:10 AM
@Kees_W Graag gedaan!
Apr 14 2020 06:56 AM
Solution