|
|
|
 Ban the ingredients for cheesecake, and stores will find substitutes. Remove the market for them, and stores have no reason to make them. - Rachel Lim [more] |
 |
|
|||||||
|
||||||||
 |
| Thread Tools | Rate Thread | Display Modes |
|
|
|
| Ban the ingredients for cheesecake, and stores will find substitutes. Remove the market for them, and stores have no reason to make them. - Rachel Lim [more] |
|
|
|||||||
|
||||||||
|
| Thread Tools | Rate Thread | Display Modes |
|
#1
|
||||
|
||||
|
Changing Sheet names with Columns (Excel)
I don't have a whole lot of experience with Excel, and the built in help is pretty unhelpful, so forgive me if I'm missing something silly.
So, lets say I have a work sheet (let's say Sheet1), and in cell A1 (on Sheet1) I have "=Sheet2!$A$2" (minus the quotes, obviously). If I were to drag this cell A1 across the row, I would get a row of of cells that go "=Sheet2!A1", "=Sheet2!A1", "=Sheet2!A1", etc. However, I want the Sheet number to change with the cell number, so it would read "=Sheet2!A1", "=Sheet3!A1", "=Sheet4!A1", etc. Is there an easy way to do this? Or must I go in by hand and change the sheet number in each row individually? 
|
|
| Thread Tools | |
| Display Modes | Rate This Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Sharing Team/Past Robot Names With New Bots | DUCKIE | General Forum | 21 | 08-02-2008 08:15 |
| Help with excel | Setsanto | Technical Discussion | 6 | 31-01-2007 13:06 |
| Kit of parts - Excel version with weight? | msbrockman | Kit & Additional Hardware | 2 | 16-01-2007 09:29 |
| Tagging Pictures with Full Names | Jaine Perotti | CD Forum Support | 3 | 06-04-2006 09:35 |
| Forgotten names/ Screen names at College Night on Pleasure Island | Elgin Clock | Championship Event | 11 | 06-05-2002 20:51 |
Linear Mode
