| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Naming Cell on differnt worksheet | Excel Worksheet Functions | |||
| Adding a row to worksheet does not update cell references in another. | Excel Worksheet Functions | |||
| How to change reference to other worksheet by changing one cell? | Excel Worksheet Functions | |||
| Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
| Refrencing another cell in a worksheet that "could" exist | Excel Worksheet Functions | |||
Threaded Mode
