Name cells on more than one worksheet

[taino8632]

Is there a way by which I could use the same name for fields on multiple worksheets?

 

[xld]

Create local names. When you define them, precede them by the sheet name, e.g.

Sheet3!myRange

or

'Data Tables'!myRange

 

[taino8632]

Create local names. When you define them, precede them by the sheet name, e.g.

Sheet3!myRange

or

'Data Tables'!myRange

Can I name every identical field on multiple sheets at the same time?