| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Naming Cell in diffetn worksheet
I make a DARTS scoring workbook with 26 Teams, each Teams as is own sheet,
So every week i enter the scores on each sheet, then using a namecell, i copy to the master sheet.... What i need to do, since i have many teams and many week to enter. On each sheet, i need to enter and name 26 cell diiferently. EX: A1=T1WK1 - A2=T1WK2 AND SO ON! As you see the naming is almost the same but only the week # Change up to 25 weeks, and on the other same thing with T# change to the team number.. I will like to know, if their a way to enter a formulas or something to do it automatically. And on my master sheet, if it possible that when i copy the cell name, it change it to the proper team and week at the same time... Ex: when i copy it in the next cell below A1=T1WK1 - A2=T2WK1 - T3WK1, then when i copy it to the next column do the following A1=T1WK1 - B1=T1WK2 - C1 =T1WK3.......AN SO ON! THX You! Yan |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Naming Cell in diffetn worksheet
Hi!
As far as naming the cells en masse, I don't know how to do that. You might be able to do it using VBA code but I don't know how. As far as copying those names (once you get them created): =INDIRECT("T"&ROWS($1:1)&"WK"&COLUMNS($A:A)) Just copy across then down. Biff "Yan" wrote in message ... I make a DARTS scoring workbook with 26 Teams, each Teams as is own sheet, So every week i enter the scores on each sheet, then using a namecell, i copy to the master sheet.... What i need to do, since i have many teams and many week to enter. On each sheet, i need to enter and name 26 cell diiferently. EX: A1=T1WK1 - A2=T1WK2 AND SO ON! As you see the naming is almost the same but only the week # Change up to 25 weeks, and on the other same thing with T# change to the team number.. I will like to know, if their a way to enter a formulas or something to do it automatically. And on my master sheet, if it possible that when i copy the cell name, it change it to the proper team and week at the same time... Ex: when i copy it in the next cell below A1=T1WK1 - A2=T2WK1 - T3WK1, then when i copy it to the next column do the following A1=T1WK1 - B1=T1WK2 - C1 =T1WK3.......AN SO ON! THX You! Yan |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Naming Cell in diffetn worksheet
How do i insert i to reflect my colums
Ok heres one of the colums i got sheet1 ( B5=T1wk1 ) So how do i make it change eveyrtime with that formulas Yan "Biff" wrote: Hi! As far as naming the cells en masse, I don't know how to do that. You might be able to do it using VBA code but I don't know how. As far as copying those names (once you get them created): =INDIRECT("T"&ROWS($1:1)&"WK"&COLUMNS($A:A)) Just copy across then down. Biff "Yan" wrote in message ... I make a DARTS scoring workbook with 26 Teams, each Teams as is own sheet, So every week i enter the scores on each sheet, then using a namecell, i copy to the master sheet.... What i need to do, since i have many teams and many week to enter. On each sheet, i need to enter and name 26 cell diiferently. EX: A1=T1WK1 - A2=T1WK2 AND SO ON! As you see the naming is almost the same but only the week # Change up to 25 weeks, and on the other same thing with T# change to the team number.. I will like to know, if their a way to enter a formulas or something to do it automatically. And on my master sheet, if it possible that when i copy the cell name, it change it to the proper team and week at the same time... Ex: when i copy it in the next cell below A1=T1WK1 - A2=T2WK1 - T3WK1, then when i copy it to the next column do the following A1=T1WK1 - B1=T1WK2 - C1 =T1WK3.......AN SO ON! THX You! Yan |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Naming Cell in diffetn worksheet
Let's assume you have these named cells:
T1WK1 refers to Sheet1!A1 T2WK1 refers to Sheet2!A1 To pull these cells into your summary sheet: =INDIRECT("T"&ROWS($1:1)&"WK"&COLUMNS($A:A)) When you copy down the formula will evaluate to: =T1WK1 =T2WK1 When you copy across the formula will evaluate to: =T1WK1.........=T1WK2 =T2WK1.........=T2WK2 That's what you wanted isn't it? That's how I interpreted it. Biff "Yan" wrote in message ... How do i insert i to reflect my colums Ok heres one of the colums i got sheet1 ( B5=T1wk1 ) So how do i make it change eveyrtime with that formulas Yan "Biff" wrote: Hi! As far as naming the cells en masse, I don't know how to do that. You might be able to do it using VBA code but I don't know how. As far as copying those names (once you get them created): =INDIRECT("T"&ROWS($1:1)&"WK"&COLUMNS($A:A)) Just copy across then down. Biff "Yan" wrote in message ... I make a DARTS scoring workbook with 26 Teams, each Teams as is own sheet, So every week i enter the scores on each sheet, then using a namecell, i copy to the master sheet.... What i need to do, since i have many teams and many week to enter. On each sheet, i need to enter and name 26 cell diiferently. EX: A1=T1WK1 - A2=T1WK2 AND SO ON! As you see the naming is almost the same but only the week # Change up to 25 weeks, and on the other same thing with T# change to the team number.. I will like to know, if their a way to enter a formulas or something to do it automatically. And on my master sheet, if it possible that when i copy the cell name, it change it to the proper team and week at the same time... Ex: when i copy it in the next cell below A1=T1WK1 - A2=T2WK1 - T3WK1, then when i copy it to the next column do the following A1=T1WK1 - B1=T1WK2 - C1 =T1WK3.......AN SO ON! THX You! Yan |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Naming Cell in diffetn worksheet
No sorry! let me explain
ON sheet1! a1 = t1wk2 Sheet1! a2=t1wk2 on every sheet it is like that except that the sheet name is the team #.. All sheet are the same.. And on my master it goes like that Team1= then each colums correspnd to the team week (EX: b1=t1wk1 b2=t1wk2 ext.... Team2= Hope this is help! Yan "Biff" wrote: Let's assume you have these named cells: T1WK1 refers to Sheet1!A1 T2WK1 refers to Sheet2!A1 To pull these cells into your summary sheet: =INDIRECT("T"&ROWS($1:1)&"WK"&COLUMNS($A:A)) When you copy down the formula will evaluate to: =T1WK1 =T2WK1 When you copy across the formula will evaluate to: =T1WK1.........=T1WK2 =T2WK1.........=T2WK2 That's what you wanted isn't it? That's how I interpreted it. Biff "Yan" wrote in message ... How do i insert i to reflect my colums Ok heres one of the colums i got sheet1 ( B5=T1wk1 ) So how do i make it change eveyrtime with that formulas Yan "Biff" wrote: Hi! As far as naming the cells en masse, I don't know how to do that. You might be able to do it using VBA code but I don't know how. As far as copying those names (once you get them created): =INDIRECT("T"&ROWS($1:1)&"WK"&COLUMNS($A:A)) Just copy across then down. Biff "Yan" wrote in message ... I make a DARTS scoring workbook with 26 Teams, each Teams as is own sheet, So every week i enter the scores on each sheet, then using a namecell, i copy to the master sheet.... What i need to do, since i have many teams and many week to enter. On each sheet, i need to enter and name 26 cell diiferently. EX: A1=T1WK1 - A2=T1WK2 AND SO ON! As you see the naming is almost the same but only the week # Change up to 25 weeks, and on the other same thing with T# change to the team number.. I will like to know, if their a way to enter a formulas or something to do it automatically. And on my master sheet, if it possible that when i copy the cell name, it change it to the proper team and week at the same time... Ex: when i copy it in the next cell below A1=T1WK1 - A2=T2WK1 - T3WK1, then when i copy it to the next column do the following A1=T1WK1 - B1=T1WK2 - C1 =T1WK3.......AN SO ON! THX You! Yan |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Naming Cell in diffetn worksheet
Sorry, but I'm just not understanding.
Biff "Yan" wrote in message ... No sorry! let me explain ON sheet1! a1 = t1wk2 Sheet1! a2=t1wk2 on every sheet it is like that except that the sheet name is the team #.. All sheet are the same.. And on my master it goes like that Team1= then each colums correspnd to the team week (EX: b1=t1wk1 b2=t1wk2 ext.... Team2= Hope this is help! Yan "Biff" wrote: Let's assume you have these named cells: T1WK1 refers to Sheet1!A1 T2WK1 refers to Sheet2!A1 To pull these cells into your summary sheet: =INDIRECT("T"&ROWS($1:1)&"WK"&COLUMNS($A:A)) When you copy down the formula will evaluate to: =T1WK1 =T2WK1 When you copy across the formula will evaluate to: =T1WK1.........=T1WK2 =T2WK1.........=T2WK2 That's what you wanted isn't it? That's how I interpreted it. Biff "Yan" wrote in message ... How do i insert i to reflect my colums Ok heres one of the colums i got sheet1 ( B5=T1wk1 ) So how do i make it change eveyrtime with that formulas Yan "Biff" wrote: Hi! As far as naming the cells en masse, I don't know how to do that. You might be able to do it using VBA code but I don't know how. As far as copying those names (once you get them created): =INDIRECT("T"&ROWS($1:1)&"WK"&COLUMNS($A:A)) Just copy across then down. Biff "Yan" wrote in message ... I make a DARTS scoring workbook with 26 Teams, each Teams as is own sheet, So every week i enter the scores on each sheet, then using a namecell, i copy to the master sheet.... What i need to do, since i have many teams and many week to enter. On each sheet, i need to enter and name 26 cell diiferently. EX: A1=T1WK1 - A2=T1WK2 AND SO ON! As you see the naming is almost the same but only the week # Change up to 25 weeks, and on the other same thing with T# change to the team number.. I will like to know, if their a way to enter a formulas or something to do it automatically. And on my master sheet, if it possible that when i copy the cell name, it change it to the proper team and week at the same time... Ex: when i copy it in the next cell below A1=T1WK1 - A2=T2WK1 - T3WK1, then when i copy it to the next column do the following A1=T1WK1 - B1=T1WK2 - C1 =T1WK3.......AN SO ON! THX You! Yan |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Naming Cell in diffetn worksheet
OK heres it is
Sheet1 = Team 1 Each team as his own sheet on column B are the weeks they played ex: B1=t1wk1 B2=t1wk2 b3=t1wk3 and so on the sheet.... So each team as the same name on each sheet except that on each sheet the team changes so on sheet 2 = TEam2 B1=t2wk1 b2=t2wk2 b3=t2wk3 and so on! for 26 Teams.. Now on my Master sheet were all the weeks are compile, i need to enter them sidways Team1= b2=t1wk1 c2=t1wk2 c2=t1wk3 and so on.. Hope this is help! Yan "Biff" wrote: Sorry, but I'm just not understanding. Biff "Yan" wrote in message ... No sorry! let me explain ON sheet1! a1 = t1wk2 Sheet1! a2=t1wk2 on every sheet it is like that except that the sheet name is the team #.. All sheet are the same.. And on my master it goes like that Team1= then each colums correspnd to the team week (EX: b1=t1wk1 b2=t1wk2 ext.... Team2= Hope this is help! Yan "Biff" wrote: Let's assume you have these named cells: T1WK1 refers to Sheet1!A1 T2WK1 refers to Sheet2!A1 To pull these cells into your summary sheet: =INDIRECT("T"&ROWS($1:1)&"WK"&COLUMNS($A:A)) When you copy down the formula will evaluate to: =T1WK1 =T2WK1 When you copy across the formula will evaluate to: =T1WK1.........=T1WK2 =T2WK1.........=T2WK2 That's what you wanted isn't it? That's how I interpreted it. Biff "Yan" wrote in message ... How do i insert i to reflect my colums Ok heres one of the colums i got sheet1 ( B5=T1wk1 ) So how do i make it change eveyrtime with that formulas Yan "Biff" wrote: Hi! As far as naming the cells en masse, I don't know how to do that. You might be able to do it using VBA code but I don't know how. As far as copying those names (once you get them created): =INDIRECT("T"&ROWS($1:1)&"WK"&COLUMNS($A:A)) Just copy across then down. Biff "Yan" wrote in message ... I make a DARTS scoring workbook with 26 Teams, each Teams as is own sheet, So every week i enter the scores on each sheet, then using a namecell, i copy to the master sheet.... What i need to do, since i have many teams and many week to enter. On each sheet, i need to enter and name 26 cell diiferently. EX: A1=T1WK1 - A2=T1WK2 AND SO ON! As you see the naming is almost the same but only the week # Change up to 25 weeks, and on the other same thing with T# change to the team number.. I will like to know, if their a way to enter a formulas or something to do it automatically. And on my master sheet, if it possible that when i copy the cell name, it change it to the proper team and week at the same time... Ex: when i copy it in the next cell below A1=T1WK1 - A2=T2WK1 - T3WK1, then when i copy it to the next column do the following A1=T1WK1 - B1=T1WK2 - C1 =T1WK3.......AN SO ON! THX You! Yan |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Naming Cell in diffetn worksheet
Now on my Master sheet were all the weeks are compile, i need to enter them
sidways Team1= b2=t1wk1 c2=t1wk2 c2=t1wk3 and so on.. That's what this formula does: =INDIRECT("T"&ROWS($1:1)&"WK"&COLUMNS($A:A)) As you copy across it will increment the week number: =T1WK1...=T1WK2...=T1WK3...=T1WK4...=T1WK5...etc And as you copt down it will increment the team number: =T1WK1 =T2WK1 =T3WK1 =T4WK1 etc If that's not correct and you want to send me your file so I can see what's going on let me know how to contact you. Biff "Yan" wrote in message ... OK heres it is Sheet1 = Team 1 Each team as his own sheet on column B are the weeks they played ex: B1=t1wk1 B2=t1wk2 b3=t1wk3 and so on the sheet.... So each team as the same name on each sheet except that on each sheet the team changes so on sheet 2 = TEam2 B1=t2wk1 b2=t2wk2 b3=t2wk3 and so on! for 26 Teams.. Now on my Master sheet were all the weeks are compile, i need to enter them sidways Team1= b2=t1wk1 c2=t1wk2 c2=t1wk3 and so on.. Hope this is help! Yan "Biff" wrote: Sorry, but I'm just not understanding. Biff "Yan" wrote in message ... No sorry! let me explain ON sheet1! a1 = t1wk2 Sheet1! a2=t1wk2 on every sheet it is like that except that the sheet name is the team #.. All sheet are the same.. And on my master it goes like that Team1= then each colums correspnd to the team week (EX: b1=t1wk1 b2=t1wk2 ext.... Team2= Hope this is help! Yan "Biff" wrote: Let's assume you have these named cells: T1WK1 refers to Sheet1!A1 T2WK1 refers to Sheet2!A1 To pull these cells into your summary sheet: =INDIRECT("T"&ROWS($1:1)&"WK"&COLUMNS($A:A)) When you copy down the formula will evaluate to: =T1WK1 =T2WK1 When you copy across the formula will evaluate to: =T1WK1.........=T1WK2 =T2WK1.........=T2WK2 That's what you wanted isn't it? That's how I interpreted it. Biff "Yan" wrote in message ... How do i insert i to reflect my colums Ok heres one of the colums i got sheet1 ( B5=T1wk1 ) So how do i make it change eveyrtime with that formulas Yan "Biff" wrote: Hi! As far as naming the cells en masse, I don't know how to do that. You might be able to do it using VBA code but I don't know how. As far as copying those names (once you get them created): =INDIRECT("T"&ROWS($1:1)&"WK"&COLUMNS($A:A)) Just copy across then down. Biff "Yan" wrote in message ... I make a DARTS scoring workbook with 26 Teams, each Teams as is own sheet, So every week i enter the scores on each sheet, then using a namecell, i copy to the master sheet.... What i need to do, since i have many teams and many week to enter. On each sheet, i need to enter and name 26 cell diiferently. EX: A1=T1WK1 - A2=T1WK2 AND SO ON! As you see the naming is almost the same but only the week # Change up to 25 weeks, and on the other same thing with T# change to the team number.. I will like to know, if their a way to enter a formulas or something to do it automatically. And on my master sheet, if it possible that when i copy the cell name, it change it to the proper team and week at the same time... Ex: when i copy it in the next cell below A1=T1WK1 - A2=T2WK1 - T3WK1, then when i copy it to the next column do the following A1=T1WK1 - B1=T1WK2 - C1 =T1WK3.......AN SO ON! THX You! Yan |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Naming Cell in diffetn worksheet
|
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Naming Cell in diffetn worksheet
when i copy it down and across it comes back with 0 value, you know why?
Yan "Biff" wrote: Now on my Master sheet were all the weeks are compile, i need to enter them sidways Team1= b2=t1wk1 c2=t1wk2 c2=t1wk3 and so on.. That's what this formula does: =INDIRECT("T"&ROWS($1:1)&"WK"&COLUMNS($A:A)) As you copy across it will increment the week number: =T1WK1...=T1WK2...=T1WK3...=T1WK4...=T1WK5...etc And as you copt down it will increment the team number: =T1WK1 =T2WK1 =T3WK1 =T4WK1 etc If that's not correct and you want to send me your file so I can see what's going on let me know how to contact you. Biff "Yan" wrote in message ... OK heres it is Sheet1 = Team 1 Each team as his own sheet on column B are the weeks they played ex: B1=t1wk1 B2=t1wk2 b3=t1wk3 and so on the sheet.... So each team as the same name on each sheet except that on each sheet the team changes so on sheet 2 = TEam2 B1=t2wk1 b2=t2wk2 b3=t2wk3 and so on! for 26 Teams.. Now on my Master sheet were all the weeks are compile, i need to enter them sidways Team1= b2=t1wk1 c2=t1wk2 c2=t1wk3 and so on.. Hope this is help! Yan "Biff" wrote: Sorry, but I'm just not understanding. Biff "Yan" wrote in message ... No sorry! let me explain ON sheet1! a1 = t1wk2 Sheet1! a2=t1wk2 on every sheet it is like that except that the sheet name is the team #.. All sheet are the same.. And on my master it goes like that Team1= then each colums correspnd to the team week (EX: b1=t1wk1 b2=t1wk2 ext.... Team2= Hope this is help! Yan "Biff" wrote: Let's assume you have these named cells: T1WK1 refers to Sheet1!A1 T2WK1 refers to Sheet2!A1 To pull these cells into your summary sheet: =INDIRECT("T"&ROWS($1:1)&"WK"&COLUMNS($A:A)) When you copy down the formula will evaluate to: =T1WK1 =T2WK1 When you copy across the formula will evaluate to: =T1WK1.........=T1WK2 =T2WK1.........=T2WK2 That's what you wanted isn't it? That's how I interpreted it. Biff "Yan" wrote in message ... How do i insert i to reflect my colums Ok heres one of the colums i got sheet1 ( B5=T1wk1 ) So how do i make it change eveyrtime with that formulas Yan "Biff" wrote: Hi! As far as naming the cells en masse, I don't know how to do that. You might be able to do it using VBA code but I don't know how. As far as copying those names (once you get them created): =INDIRECT("T"&ROWS($1:1)&"WK"&COLUMNS($A:A)) Just copy across then down. Biff "Yan" wrote in message ... I make a DARTS scoring workbook with 26 Teams, each Teams as is own sheet, So every week i enter the scores on each sheet, then using a namecell, i copy to the master sheet.... What i need to do, since i have many teams and many week to enter. On each sheet, i need to enter and name 26 cell diiferently. EX: A1=T1WK1 - A2=T1WK2 AND SO ON! As you see the naming is almost the same but only the week # Change up to 25 weeks, and on the other same thing with T# change to the team number.. I will like to know, if their a way to enter a formulas or something to do it automatically. And on my master sheet, if it possible that when i copy the cell name, it change it to the proper team and week at the same time... Ex: when i copy it in the next cell below A1=T1WK1 - A2=T2WK1 - T3WK1, then when i copy it to the next column do the following A1=T1WK1 - B1=T1WK2 - C1 =T1WK3.......AN SO ON! THX You! Yan |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Naming Cell in diffetn worksheet
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How:Add New Worksheet that copies the cell of the previous sheet | Excel Worksheet Functions | |||
| How do I get ONLY new info from 1 Worksheet to another automatical | Excel Worksheet Functions | |||
| fill cell with color from other worksheet | Excel Discussion (Misc queries) | |||
| Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
| Refrencing another cell in a worksheet that "could" exist | Excel Worksheet Functions | |||
Linear Mode
