K
kterry
a question from my son, how can you copy cells with the cell names from an
existing spread sheet into a new spread sheet?
thanks
existing spread sheet into a new spread sheet?
thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
AltaEgo
I am not full clear what he wants to copy. If it is named ranges, just refer
to the in his new sheet.
For example, If he has named cell A1 on Sheet1 taxRate , all he needs to do
in any cell in any other sheet (or Sheet1) to refer to the value stored in
taxRate is enter =taxRate. To make this a formula =A3*taxRate.
Does this help?
More on working with named ranges
http://www.cpearson.com/excel/named.htm
If the above missed the mark, perhaps he can copy the whole spreadsheet to a
new sheet.
Click on the tab of the target sheet
Press the [Ctrl] key and drag the tab to its required new location - voila,
a copy is created.
to the in his new sheet.
For example, If he has named cell A1 on Sheet1 taxRate , all he needs to do
in any cell in any other sheet (or Sheet1) to refer to the value stored in
taxRate is enter =taxRate. To make this a formula =A3*taxRate.
Does this help?
More on working with named ranges
http://www.cpearson.com/excel/named.htm
If the above missed the mark, perhaps he can copy the whole spreadsheet to a
new sheet.
Click on the tab of the target sheet
Press the [Ctrl] key and drag the tab to its required new location - voila,
a copy is created.
K
kterry
The way he explained it to me, was if you named cell A1 "fred" how could
you copy it into a new spreadsheet without doing "insert names" again. I
believe it is a type of inventory spreadsheet and he is having a lot of
named cells that he is having to reenter in each new sheet, but not all of
them on each sheet.
Does that help?
you copy it into a new spreadsheet without doing "insert names" again. I
believe it is a type of inventory spreadsheet and he is having a lot of
named cells that he is having to reenter in each new sheet, but not all of
them on each sheet.
Does that help?
AltaEgo said:I am not full clear what he wants to copy. If it is named ranges, just
refer to the in his new sheet.
For example, If he has named cell A1 on Sheet1 taxRate , all he needs to
do in any cell in any other sheet (or Sheet1) to refer to the value stored
in taxRate is enter =taxRate. To make this a formula =A3*taxRate.
Does this help?
More on working with named ranges
http://www.cpearson.com/excel/named.htm
If the above missed the mark, perhaps he can copy the whole spreadsheet to
a new sheet.
Click on the tab of the target sheet
Press the [Ctrl] key and drag the tab to its required new location -
voila, a copy is created.
--
Steve
kterry said:a question from my son, how can you copy cells with the cell names from
an existing spread sheet into a new spread sheet?
thanks
A
Alexander Wolff
Die Tastatur von kterry wurde wie folgt gedrückt:
He might MOVE the sheet (right-click the sheet tab, not forgetting to tick
[X] COPY) and then edit it/delete cells he would not need. There is no other
way, since cell names are not a property of cells - they are property of the
sheet).
a question from my son, how can you copy cells with the cell names
from an existing spread sheet into a new spread sheet?
He might MOVE the sheet (right-click the sheet tab, not forgetting to tick
[X] COPY) and then edit it/delete cells he would not need. There is no other
way, since cell names are not a property of cells - they are property of the
sheet).
A
AltaEgo
Normally, named ranges are created so they can be referred to in a workbook
from any sheet. It sounds like the requirement is to have a named range that
refers to the same cell address relative to the sheet that is currently
active. I suspect VBA is required to copy named ranges so they appear in
each sheet but only refer to the active sheet.
It can be done manually:
1)Activate the first sheet (say, Sheet1)
2)Select the relevant range (say A1:C3)
3)Click in the Name Box.
4)Type Sheet1!MyName (where MyName is the required name)
5)Push Enter
Repeat for other sheets required, ensuring the sheet name is changed each
time (e.g on Sheet2 the name entered would be Sheet2!MyName).
The simple way is to copy existing names so they relate only to new sheet is
to hold the [Ctrl] key and drag the sheet tab to a new location so it
creates a copy. The new copy will contain named ranges the same as the
original sheet but these names will be relevant to the new sheet only.
Example
Assume taxRate is a named cell in Sheet1 that refers to A1
Entering the formula =taxRate in any cell in the workbook will provide the
value recorded in the relevant cell in Sheet1.
Perform the above [Ctrl]-drag on Sheet1. A new sheet is created - Sheet1
(2).
Entering =taxRate in Sheet1 (2) refers only to the value recorded in cell A1
of this sheet. All other sheets refer to taxRate as recorded in the original
sheet.
--
Steve
from any sheet. It sounds like the requirement is to have a named range that
refers to the same cell address relative to the sheet that is currently
active. I suspect VBA is required to copy named ranges so they appear in
each sheet but only refer to the active sheet.
It can be done manually:
1)Activate the first sheet (say, Sheet1)
2)Select the relevant range (say A1:C3)
3)Click in the Name Box.
4)Type Sheet1!MyName (where MyName is the required name)
5)Push Enter
Repeat for other sheets required, ensuring the sheet name is changed each
time (e.g on Sheet2 the name entered would be Sheet2!MyName).
The simple way is to copy existing names so they relate only to new sheet is
to hold the [Ctrl] key and drag the sheet tab to a new location so it
creates a copy. The new copy will contain named ranges the same as the
original sheet but these names will be relevant to the new sheet only.
Example
Assume taxRate is a named cell in Sheet1 that refers to A1
Entering the formula =taxRate in any cell in the workbook will provide the
value recorded in the relevant cell in Sheet1.
Perform the above [Ctrl]-drag on Sheet1. A new sheet is created - Sheet1
(2).
Entering =taxRate in Sheet1 (2) refers only to the value recorded in cell A1
of this sheet. All other sheets refer to taxRate as recorded in the original
sheet.
--
Steve
kterry said:The way he explained it to me, was if you named cell A1 "fred" how could
you copy it into a new spreadsheet without doing "insert names" again. I
believe it is a type of inventory spreadsheet and he is having a lot of
named cells that he is having to reenter in each new sheet, but not all of
them on each sheet.
Does that help?
AltaEgo said:I am not full clear what he wants to copy. If it is named ranges, just
refer to the in his new sheet.
For example, If he has named cell A1 on Sheet1 taxRate , all he needs to
do in any cell in any other sheet (or Sheet1) to refer to the value
stored in taxRate is enter =taxRate. To make this a formula =A3*taxRate.
Does this help?
More on working with named ranges
http://www.cpearson.com/excel/named.htm
If the above missed the mark, perhaps he can copy the whole spreadsheet
to a new sheet.
Click on the tab of the target sheet
Press the [Ctrl] key and drag the tab to its required new location -
voila, a copy is created.
--
Steve
kterry said:a question from my son, how can you copy cells with the cell names from
an existing spread sheet into a new spread sheet?
thanks
K
kterry
Thank you, that answered his question
Alexander Wolff said:Die Tastatur von kterry wurde wie folgt gedrückt:a question from my son, how can you copy cells with the cell names
from an existing spread sheet into a new spread sheet?
He might MOVE the sheet (right-click the sheet tab, not forgetting to tick
[X] COPY) and then edit it/delete cells he would not need. There is no
other way, since cell names are not a property of cells - they are
property of the sheet).