Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Make Excel hyperlinks local to current sheet
I have a sheet, SHEET1, that I have some hyperlinks that jump from cell b10 to cell ac55. Once I have SHEET1 formatted the way I want, I want to copy it to SHEET2. The problem is, the hyperlinks are copied, but in SHEET2 they still point back to 'Sheet1'!AC55. Am I creating them wrong? I...- patme
- Thread
- Replies: 6
- Forum: Microsoft: Office
-
Use next number from list on another sheet
Worksheet1 contains a list of numbers, 101-199, in cells a1 through a99. Worksheet2 looks like this: A1 101 A2 102 A3 103 Worksheet3 looks like this: A1 104 A2 105 A3 106 How can I make Worksheet2 look like this?: B1 107 B2 108 | B14 120 C1 109 C2 110 | C10 118 Basically, I want to...- patme
- Thread
- Replies: 18
- Forum: Microsoft: Office
-
Tally wins-losses in Excel
Okay, I've tried and tried to figure this out, and I can't, so I'm coming to the experts. One of these days I hope to give back to this list as much as I've learned from it. I have a wrestling program set up. I have 6 kids wrestling. Each kid wrestles one of the other kids once. I have a...- patme
- Thread
- Replies: 2
- Forum: Microsoft: Office
-
Use formula to name cells
Is there a way to use a formula, VBA, etc., to use the info in cells to name another cell? For example, in the cells below, I would like to NAME Cell C1 "401", and NAME C2 "402", etc. A B C 1 40 1 2 40 2 3 40 3- patme
- Thread
- Replies: 9
- Forum: Microsoft: Office
