| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Defined Names in Formulas when copying Worksheets in a Workbook
How do I understand the effects on Table names when copying a worksheet
within a workbook. I am new to Tables and Defined NAmes. I have formulas that work on one worksheet but when I copy to use for next month in a workbook my name scopes get confusing. Every Table name appears to be Workbook scope and a copy adds a number representing the next table number added to the workbook. So I have defined tables (Monthly_Sales, Monthly_Sales1, Monthly_Sales12, Monthly_Sales123, etc.) Is there a better way? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Defined Names in Formulas when copying Worksheets in a Workbook
Perhaps this discussion over on Chip Pearson's site will help you out:
http://www.cpearson.com/Excel/DefinedNames.aspx "Todd_Loves_Spreadsheets" wrote: How do I understand the effects on Table names when copying a worksheet within a workbook. I am new to Tables and Defined NAmes. I have formulas that work on one worksheet but when I copy to use for next month in a workbook my name scopes get confusing. Every Table name appears to be Workbook scope and a copy adds a number representing the next table number added to the workbook. So I have defined tables (Monthly_Sales, Monthly_Sales1, Monthly_Sales12, Monthly_Sales123, etc.) Is there a better way? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Defined Range Names in formulas | Excel Discussion (Misc queries) | |||
| Defined Names in Workbook | Excel Worksheet Functions | |||
| Tranferring names defined in one excel workbook to another workboo | Excel Discussion (Misc queries) | |||
| How to delete all defined names from a workbook? | Excel Worksheet Functions | |||
| How to delete all defined names from a workbook? | Links and Linking in Excel | |||
Linear Mode
