Create Names and Named Formula At Once

[chunlee]

Given a list of names and "refer to", is there a way to create names and fill the "refer to" field at once?

"refer to" consist of formula and range. Thanks in advance.

 

[Luke M]

Sure thing. Generally, you'll want to first format the cells you are putting the formula/refer to as text, so that you can write the formula. Then, you can do something like:

[pre]

Range1    =A1
Range2    =OFFSET(A1,B1)

[/pre]
Select this range, and then if using

2003:

Insert - Name - Create from List

2007:

Formula - Create From Selection

 

[Hui]

Chunlee


Firstly, Welcome to the Chandoo.org Forums.


I'm note sure I totally understand your requirements but you may want to have a look at a Technique I have described here : http://chandoo.org/wp/2011/06/23/automating-repetitive-tasks/