I need data from many sheet into one chart (In its own sheet).
I know how to do it when its from from sheet (In this example, sheet named
Pernille) :
=Pernille!$AS$10
I tried this :
=Pernille!$AS$10;Aase!$AS$10
But the reference was not valid.
Please help, I havent been able to find anything, not even in my E-learning.