Assigned Names is a workbook object and not a sheet object. What
sometimes do is to strip off the sheet name form the named object so
can use the object on more than one sheet.
You are trying to use the same name on two different sheet which can'
be done. What can be done is to use a cell data to identify where
table starts. What some people do is to put on the worksheet somethin
like "Yearly Expense". Then use FIND to locate the cell where "Yearl
Expense" is located to find the beginning of a range of cells.
