Hi,
I am dumping data into sheets and naming them with dates, I want to have a master sheet that pulls info from lots of various sheets but I only want to type the sheet name once, not 25 times inserting it into formulas, by typing the sheet name into one cell and a formula referencing it, but it doesn’t seem to work.
here is an example.
this works
=AVERAGE(‘20-07-16’.C1383:C1442)
but I want to use some thing like
=AVERAGE(A32.C1383:C1442)
where A32 is a sheet name?
Any thoughts on why this won’t work?
Many thanks
Jim