How do I copy columns when part of formula has another sheet in it?

I want it to formulate from row 1a, 2a, 3a, 4a, 5a, etc.

But the standard copy function goes 1a, 1b, 1c, 1d, 1e, etc.

Does this make sense?

Source data assumed in Sheet1, starting in A2 across/down

In Sheet2,

Place this in any starting cell, say in B2:

=OFFSET(Sheet1!$A$2,COLUMNS($A:A)-1,ROWS($1:1)-1)

Copy across and fill down as desired to populate a "transpose" view of the

source data in Sheet1.

--

Max

Singapore

http://www.yqcomputer.com/

xdemechanik

---

In Sheet2,

Place this in any starting cell, say in B2:

=OFFSET(Sheet1!$A$2,COLUMNS($A:A)-1,ROWS($1:1)-1)

Copy across and fill down as desired to populate a "transpose" view of the

source data in Sheet1.

--

Max

Singapore

http://www.yqcomputer.com/

xdemechanik

---

1. Formula if Column E in Sheet 1 equals Column M in sheet 2, = Colum

2. Copying columns from multiple sheets in a single sheet based on a column value.

3. copying a template sheet and inputting a formula into another sheet that references the new sheet

4. My I's are coming up i's. (lower case)

5. How to retain column width and formulas in copying a sheet

6. carrying over a column formula from one sheet to another copied sh

7. How to copy part of a sheet as a new sheet into another workbook?

8. when copying sheet, warning that formula or sheet

9. How to copy formulas sheet to sheet in excell

10. copy values generated by conditional formula in one sheet to the other work sheet as values

11. Copy formula...sheet 2 sheet

12. copy a sum in cell on sheet 1 (not formula) to cell on sheet 2

13. Formula to copy related information from sheet 1 to sheet 2

14. copy formula referencing sheet name to another sheet

2 post • Page:**1** of **1**