Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I copy columns when part of formula has another sheet in it
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy part of large WS to another sheet | Excel Worksheet Functions | |||
How do i copy rows to columns on separate sheet, and have them upd | Excel Worksheet Functions | |||
macro to copy columns to sheet | Excel Discussion (Misc queries) | |||
Copy cell formating as part of a formula | Excel Worksheet Functions | |||
How do I copy a formula in excel where part remains absolute the . | Excel Discussion (Misc queries) |