G
greg
I need to know how to use a cell value as part of
worksheet name in a formula. I have a number in column A,
and want to use it as an index for the worksheet name.
Example: run number in column A, average value from cells
d2 thru d4 (from another worksheet) in column B. So
something like "=average('sheetname|A1'd2:d4)". The other
worksheets all have a common prefix with a number at the
end.
worksheet name in a formula. I have a number in column A,
and want to use it as an index for the worksheet name.
Example: run number in column A, average value from cells
d2 thru d4 (from another worksheet) in column B. So
something like "=average('sheetname|A1'd2:d4)". The other
worksheets all have a common prefix with a number at the
end.
44"))