|
|
#1
11-03-2015, 07:30 AM
|
|||
|
|||
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. 
|
| Tags |
| cell names, data |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Propagating a formula which references a named cell | Splint | Excel | 4 | 06-15-2015 04:55 AM |
 getting the worksheet name in a cell
|
derohanes | Excel | 9 | 02-14-2013 01:29 PM |
| Can't use a zero in a named cell | TechEd | Excel | 2 | 10-16-2012 10:06 PM |
|
Cell formating on Protected worksheet
|
AHB | Excel Programming | 2 | 02-27-2012 10:25 AM |
| click a cell to go to a worksheet | victor | Excel | 0 | 10-27-2006 02:57 PM |
Windows 10 
Office 2013
Threaded Mode