View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Yan Yan is offline
external usenet poster
 
Posts: 33
Default 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!