Defined Names in Formulas when copying Worksheets in a Workbook

  • Thread starter Thread starter Todd_Loves_Spreadsheets
  • Start date Start date
T

Todd_Loves_Spreadsheets

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?
 
Back
Top