Referencing cells

[Ed]

Hi,



I posted earlier but got no response. I think my explanation then was too
difficult to understand so I'm trying again. I hope this time it is more
easily understandable



In Workbook 1 "Exp_06.xls", I have a column of numbers starting on row 23 as
shown.



23 1000

24 500

etc.etc.



Each cell in the column is named, for example cell "A23" is named
"AutoInsurance" and cell "A24" is named "AutoGasoline". The formula bar for
each cell contains only the number in the cell and does not reference the
cells name.



In Workbook 2, I have the same column of numbers but with the formula bar
referencing each cell in Workbook 1 as follows:



23 =[Exp_06.xls]Exp_06!E23

24 =[Exp_06.xls]Exp_06!E24

etc etc



In Workbook2, I want the cells in the column to refer to the cell names from
Workbook 1, for example



23 =Exp_06.xls!AutoInsurance

24 =Exp_06.xls!AutoGasoline



How can I do this for the entire column?

Thanks very much.

 

[Lori]

Use Insert > Name > Apply to update formulas with names.

This applies only to formulas entered on the same sheet as the named
ranges they refer to so first enter the formulas =E23, =E24,... on the
sheet containing the names then apply names and then cut and paste to
the other workbook.

 

[Ed]

Thanks, Lori, it works great.

Use Insert > Name > Apply to update formulas with names.

This applies only to formulas entered on the same sheet as the named
ranges they refer to so first enter the formulas =E23, =E24,... on the
sheet containing the names then apply names and then cut and paste to
the other workbook.

Hi,

I posted earlier but got no response. I think my explanation then was too
difficult to understand so I'm trying again. I hope this time it is more
easily understandable

In Workbook 1 "Exp_06.xls", I have a column of numbers starting on row 23
as
shown.

23 1000

24 500

etc.etc.

Each cell in the column is named, for example cell "A23" is named
"AutoInsurance" and cell "A24" is named "AutoGasoline". The formula bar
for
each cell contains only the number in the cell and does not reference the
cells name.

In Workbook 2, I have the same column of numbers but with the formula bar
referencing each cell in Workbook 1 as follows:

23 =[Exp_06.xls]Exp_06!E23

24 =[Exp_06.xls]Exp_06!E24

etc etc

In Workbook2, I want the cells in the column to refer to the cell names
from
Workbook 1, for example

23 =Exp_06.xls!AutoInsurance

24 =Exp_06.xls!AutoGasoline

How can I do this for the entire column?

Thanks very much.