| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
same named cell in separate worksheets
Excel will define print_areas for separate worksheets in a workbook. If I recall correctly, in the past, you could define named cells that were specific to a worksheet... I've got a workbook consisting of several similar worksheets each with a 'total' entry and a summary page which lists the totals... I'd like to reference the totals via named cells rather than absolute references (i.e., 'ws1'!total vs 'ws1'!$b$14)... TIA Al -- Al.Caughey ------------------------------------------------------------------------ Al.Caughey's Profile: http://www.excelforum.com/member.php...o&userid=35393 View this thread: http://www.excelforum.com/showthread...hreadid=551847 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reference Cell Color From Other WorkSheets | Excel Worksheet Functions | |||
| Save 2 separate data imports in separate worksheets on the same ex | Excel Worksheet Functions | |||
| copying cell names | Excel Discussion (Misc queries) | |||
| Can a worksheet pull from a specific cell value in a separate wrks | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
