|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 5th, 2006, 02:14 PM
posted to rec.outdoors.fishing.fly
|
|||
|
|||
Geek Question
In Excel, how can I make worksheet references relative?
For example, I want to insert the following in row 3, in cells A through Z: Sheet2!$B$5 Sheet3!$B$5 Sheet4!$B$5 Sheet5!$B$5 etc. I know how to make the cell number absolute (with the $-signs), but I cannot get the 'fill' to change the sheets when I drag the function command across the different cells in row 3: it keeps the worksheet reference absolute, referencing Sheet2. How can I make the worksheet reference relative, so it changes the sheet number for each successive cell? --riverman 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| parachute worth question...... | Sandy Pittendrigh | Fly Fishing Tying | 13 | April 17th, 2006 03:31 PM |
| Sonar Question | Joshuall | Bass Fishing | 7 | February 8th, 2005 11:15 AM |
| Easy Geek question | Tim J. | Fly Fishing | 20 | September 1st, 2004 01:12 PM |
| Easy Geek question | riverman | Fly Fishing | 18 | September 1st, 2004 12:49 PM |
| Another GEEK question | riverman | Fly Fishing | 13 | December 12th, 2003 12:01 AM |
Threaded Mode