Range names selected from within a cell

  • Thread starter Thread starter Alan Hines
  • Start date Start date
A

Alan Hines

Hi, hope you can help.

I have a number of named ranges across a workbook. In 1
summary sheet I want to be able to enter a range name and
then other cells containnig a formula referring to the
cell I typed the range name in to in order to calculate.

An example in cell A1 i would input "Name" as the cell
content.

Then in cell A2 the following formula would be used "=sum
(A1). I get an error message, and I need to have the
flexibility to type or select from a list a whole number
of range names into cell A1 to get the required
calculation in cell A2.

Any suggestions?

Many thanks,
Alan
 
Back
Top