Thread: How do I copy columns when part of formula has another sheet in it
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default How do I copy columns when part of formula has another sheet in it
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://savefile.com/projects/236895
xdemechanik
---
"andrewwatkins" wrote:
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?
Reply With QuoteReply With Quote