| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do I automatically (using a formula like =SHEET1!A$1) referen.
I want to reference the values of row (all columns) 1 in sheet 1, in a
columns (horizontally) in sheet 2. The formula should look something like this: =SHEET1!A$1 This is a problem, cause the "A" in the formula stays constant, and needs to change to B,C,D,E,F,etc. How do I get it to change when filling the formula by dragging? |
|
#2
|
|||
|
|||
|
Take a look at the Transpose function.
It should give you the desired result. Per Erik On Wed, 23 Feb 2005 09:01:15 -0800, "Rynardt" wrote: I want to reference the values of row (all columns) 1 in sheet 1, in a columns (horizontally) in sheet 2. The formula should look something like this: =SHEET1!A$1 This is a problem, cause the "A" in the formula stays constant, and needs to change to B,C,D,E,F,etc. How do I get it to change when filling the formula by dragging? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| How do I create a formula in excel to automatically copy text fro. | Excel Discussion (Misc queries) | |||
| formula to have each new invoice automatically have the next numb | Excel Discussion (Misc queries) | |||
| How do I write my formula to automatically regenerate a RAND () i. | Excel Worksheet Functions | |||
Hybrid Mode
