Range names selected from within a cell

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A find formul looking at two named ranges for two strings 8
Pasting a cell into bookmarked table from excel vba 1
Vlookup and return sheet name also 2
Finding the proper style field and the numbered paragraph value within the style 0
copy cell range in other sheet 1
How do I have a cell value define a dynamic named range? 15
Multiple Criteria, One Answer 1
Show value from one cell in another cell if today falls between a date range 5

Top