I currently have a workbook containing worksheets named as years. I found that if i named a cell in 1 worksheet (example 2015) then the data in that name carries over into each of the other 30 worksheets. I'm trying to name a cell, ie: "regpay", which the data in that cell would only be used in that specific sheet.....so if needed i could use "regpay" in a 2016 worksheet that would allow differant data in that cell.....




make sense???


any help appreciated.

In the Name Manager when creating the name set the scope to that worksheet, not Workbook.

can I change them in Name Manager if they've already been created and named??

Unfortunately not. You have to create new worksheet-scoped ones and then delete the workbook level versions. You could do it with a bit of code if there are a lot of them, and you want to make all of them local to the sheet they refer to.