I have named a single column range as "Range". What is the best way to copy
these values to other worksheets if this range can be changed in future?
For e.g.:
Worksheet 1:
A
1 Value1
2 Value 2
3 Value 3
4 Value 4

$A$1:$A$4 has been named "Range".

Worksheet 2:
A
1 =Worksheet1!A1
2 =Worksheet1!A2
etc.
i don't like this method as I will have to make sure the formula is copied
to enough cells to display the full values in "Range". Can anybody suggest a
better, fool-proof way?

Note: You need not have to define a Name for the Column Range heading.

Do the following

1. Click on Column A, the column A is selected.
2. On the Edit menu, Click Copy.
3. Click the other Worksheet tab
4. Click the A Column heading
5. On the Edit menu, click Paste Special
6. On the Tools menu, Click Options
7. In the Options dialog box, Click the View tab.
8. Under Windows Options, Clear the Zero values check box.
9.Click OK.

Challa Prabhu

Got to your second workbook and select A1 and select Paste Special - Paste
link.
Any changes to Column A in the first workbook will now be automatically
updated in the second.



"Melissa" wrote:

I have named a single column range as "Range". What is the best way to copy
these values to other worksheets if this range can be changed in future?
For e.g.:
Worksheet 1:
A
1 Value1
2 Value 2
3 Value 3
4 Value 4

$A$1:$A$4 has been named "Range".

Worksheet 2:
A
1 =Worksheet1!A1
2 =Worksheet1!A2
etc.
i don't like this method as I will have to make sure the formula is copied
to enough cells to display the full values in "Range". Can anybody suggest a
better, fool-proof way?

Melissa,

One option.

Select the entire column where your range is stored and select COPY
Got to your second workbook and select A1 and select Paste Special - Paste
link.
Any changes to Column A in the first workbook will now be automatically
updated in the second.

Mike

"Melissa" wrote:

I have named a single column range as "Range". What is the best way to copy
these values to other worksheets if this range can be changed in future?
For e.g.:
Worksheet 1:
A
1 Value1
2 Value 2
3 Value 3
4 Value 4

$A$1:$A$4 has been named "Range".

Worksheet 2:
A
1 =Worksheet1!A1
2 =Worksheet1!A2
etc.
i don't like this method as I will have to make sure the formula is copied
to enough cells to display the full values in "Range". Can anybody suggest a
better, fool-proof way?