Define a generic name
I have created a template which will be used to create customer profiles
problem here is I want to use names (example Cells A1:A100 = date) without associating it to the name of the worksheet. So instead of Date = worksheet1!A1:A100 , I just want Date = A1:100 Can this be done ? -- Nelson |
Define a generic name
Nelson wrote:
I have created a template which will be used to create customer profiles problem here is I want to use names (example Cells A1:A100 = date) without associating it to the name of the worksheet. So instead of Date = worksheet1!A1:A100 , I just want Date = A1:100 Can this be done ? Try this: =INDIRECT("A1:A100") |
Define a generic name
How do you intend to use the name Date?
You can do something like this: InsertNameDefine Name: Date Refers to: =INDIRECT("A1:A100") Then, Date will refer to A1:A100 of the sheet where you use the name. For example, if you enter this formula in cell B1 of Sheet2: =SUM(Date) You'll get: =SUM(Sheet2!A1:A100) The big problem with this is that it will *always* refer to A1:A100. So if you were to insert new rows/columns that would change the range, the referenced range *won't* change. -- Biff Microsoft Excel MVP "Nelson" wrote in message ... I have created a template which will be used to create customer profiles problem here is I want to use names (example Cells A1:A100 = date) without associating it to the name of the worksheet. So instead of Date = worksheet1!A1:A100 , I just want Date = A1:100 Can this be done ? -- Nelson |
Define a generic name
Just a warning...
I wouldn't use Date as the range name. It looks way too close to the excel function =date(). Nelson wrote: I have created a template which will be used to create customer profiles problem here is I want to use names (example Cells A1:A100 = date) without associating it to the name of the worksheet. So instead of Date = worksheet1!A1:A100 , I just want Date = A1:100 Can this be done ? -- Nelson -- Dave Peterson |
All times are GMT +1. The time now is 12:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com