| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
same named cell in separate worksheets
Hi
Select your cell and go to Insert/ Name/Define. Give your cell the name ws1!total for sheet ws1 etc. As long as you prefix the name with the worksheet, it should work! Hope this helps. Andy. "Al.Caughey" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
same named cell in separate worksheets
Thanks Andy... your suggestion works beautifully. -- 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 |
| Reply |
| 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 | |||
Linear Mode
