I am trying to create a chart that sources data from multiple worksheets within the same workbook. All the cells are the same location in each worksheet.
I keep getting an error message on the formula entered under the value box.
='Aug 05:Dec 05'!$BA$111
This formula kicks back an error highlighting 'Aug
I have tried different variations of this formula, but nada.
What am I missing?
I keep getting an error message on the formula entered under the value box.
='Aug 05:Dec 05'!$BA$111
This formula kicks back an error highlighting 'Aug
I have tried different variations of this formula, but nada.
What am I missing?