Naming same cell in different worksheet with 2 value changing on e
Hi!
I have a problem?
i am trying to name a cell on my sheet1 = t1wk1 and on sheet2 i would like
that cell to be name t2wk1 and so on....
and after on each sheet i i have sheet1 a1=t1wk1 and a2=t1wk2 and a3=t1wk3
and so on....
NOW ON MY MASTER SHEET!
I need to get the cells to refer to those cell for each team....
Ex: a1 value will be "=t1wk1" , b1 value will be "=t1wk2" and so on
i would like to know, if their a way to do that automatically instead of
just typing them...
Thx you!
|