Thread: [Solved] how do i use a named cell for each worksheet
View Single Post
 
Old 11-03-2015, 07:30 AM
cwkotch cwkotch is offline Windows 10 Office 2013
Novice
  
Join Date: Oct 2015
Posts: 16
cwkotch is on a distinguished road
Default how do i use a named cell for each worksheet
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.
Reply With Quote