Thread: copy ???
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jason Morin Jason Morin is offline
external usenet poster
 
Posts: 63
Default copy ???

With your data in A1:CR64 in Sheet1, put this in A1 in
another sheet and drag down:

=OFFSET(Sheet1!$A$1,INT(ROW()/97),MOD(ROW()-1,96),)

Or, more generally, use:

=OFFSET(INDIRECT(MID(CELL("address",rng),FIND("]",CELL
("address",rng))+1,99)),INT(ROW()/97),MOD(ROW()-1,96),)

where "rng" = your range, 96 col x 64 rows.

HTH
Jason
Atlanta, GA

-----Original Message-----
HI

I have a 64 X 96 field with data and want to bring the

96 columns in one
column so that column Nr1s 64 entries are followed by

column Nr2s entries. Is
that possible from another worksheet, too?

Thanks
ANDY
.