Define Name in sheet to be unique to that sheet

[ejwjohn]

I have a workbook that contains a number of worksheets with similar tables in them, within each sheet there is a folumal that contains a range of cells identified by a NAME, the range of cells contain data that changes from worksheet to worksheet, but the NAME is linked to the specific worksheet that is originally used to define the NAME ....
Is there anyway to define a NAME in a worksheet so that when you copy (duplicate and rename) the worksheet into the same workbook the NAME assumes the Cells within the new duplicated and renamed worksheet.

Sorry a little complicated to describe.

Thanks

John

 

[RoryA]

If you define the name as local to the sheet (e.g. using Sheet1!Test as the name rather than just Test) then it should work as you want.

 

[ejwjohn]

Great super fast response ...thank you

John