ExcelBanter - How do I automatically (using a formula like =SHEET1!A$1) referen.

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I automatically (using a formula like =SHEET1!A$1) referen. (https://www.excelbanter.com/excel-worksheet-functions/14642-how-do-i-automatically-using-formula-like-%3Dsheet1-%241-referen.html)

Rynardt

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?

Per Erik Midtrød

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?

All times are GMT +1. The time now is 08:50 PM.