How to name cells using same name yet specific to worksheet in Exc
If I'm understanding you correctly all you have to do is put the name of the
worksheet and an ! in front of your cell reference, i.e.
=Worksheet B!D5
will reference cell D5 in Worksheet B
HTH
|