cell names

E

Ed

I have a sheet with a column of numbers. Each cell in the column that
contains a number is named. I want to transfer these numbers to a column in
a second sheet so that each cell in the second sheet references the cell
name from the first sheet, allowing any changes in the first sheet number to
automatically appear in the second sheet.

I know how to do this manually for each cell but how can I transfer the
entire column at one time.

Thanks for all help.
 
G

Gary''s Student

You don't need to refer to the names. Select the entire source column and:
Edit > Copy

Select the top cell in the destination column and:
Edit > Paste Special > as link
 
Top