Cell names

billythekidcal

New Member
Joined
Jun 4, 2002
Messages
15
Does anyone know how to name cells that are specific to a worksheet? ie. so you can use the same name on different worksheets and each name refers to a range in the worksheet. When you have a name that is specific to the sheet, will show a worksheet in the defined name, but I don't know how you set up a name so that it comes up this way. Anyone?

Thanks in advance.
 
andrew - it worked, that's awesome. thanks for your help.
aladin - andrew's instructions work great.
To do what you were asking you'd:
1. Select cell A1 on Sheet1.
2. Insert|Name|Define...
3. Enter "Sheet1!Billy" in the define names box.
4. Click OK
1. Select cell B10 on Sheet2.
2. Insert|Name|Define...
3. Enter "Sheet2!Billy" in the define names box.
4. Click OK

Works great, thanks again Andrew.
 
Upvote 0

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
On 2002-10-18 12:43, billythekidcal wrote:
andrew - it worked, that's awesome. thanks for your help.
aladin - andrew's instructions work great.
To do what you were asking you'd:
1. Select cell A1 on Sheet1.
2. Insert|Name|Define...
3. Enter "Sheet1!Billy" in the define names box.
4. Click OK
1. Select cell B10 on Sheet2.
2. Insert|Name|Define...
3. Enter "Sheet2!Billy" in the define names box.
4. Click OK

Works great, thanks again Andrew.

Sheet1!Billy and Sheet2!Billy is not the same name. :grin:
 
Upvote 0
Andrew - you're right, thanks for your help.
Aladin - follow andrew's instructions, go to sheet 1 and define "Sheet1!Billy" in the Names in Workbook box and refers to =Sheet1!A1 , and then go to Sheet 2 and define the name "Sheet2!Billy" in the Names in Workbook box and refers to Sheet2!B10.

Thanks again Andrew. This one has been stumping me for a long time.
 
Upvote 0
Aladin,

On Sheet1 =Billy returns the reference to the name on Sheet1. While =Sheet2!Billy returns the reference to the name on Sheet2.

I hope!
 
Upvote 0
Curious as to why you need the same name in each sheet? Seems like asking for an error unseen.
 
Upvote 0
It allows me to lookup the same thing in various worksheets with varying structures. I have an excel database that contains too many records for one worksheet, and this is the easiest way.
 
Upvote 0
Magic again.
The names do not seem to be global but local to the sheet they were created in.

Amazing Andrew!
 
Upvote 0

Forum statistics

Threads
1,223,098
Messages
6,170,099
Members
452,301
Latest member
QualityAssurance

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top