same named cell in separate worksheets

[Al.Caughey]

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

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[Al.Caughey]

Thanks Andy... your suggestion works beautifully.