use the contents of a cell in a function ... ??
I have a workbook with 22 worksheets. Each sheet is named for an
author, say `Able' through ... `Yangtze.' One the front sheet, I have
the list of authors in a column. How do I write the MAX, AVERAGE, and
MEDIAN commands so that I do not have to rewrite the names of the
worksheets in each cell, ie:
=AVERAGE(`THE NAME IN COLUMN A!$B$2:$B$1000)
thanks in advance.
|