Linking cell ranges between rows and columns
 

I'm OK with linking and transposing cells but what I need to do is to link
ranges. EXAMPLE: I have multiple cell ranges in Sheet 1 :

A1-B1-C1
A2-B2-C2
A3-B3-C3

Is there a direct way to link those row ranges in Sheet 1 with corresponding
column ranges in Sheet 2?:

A1-B1-C1(Sheet 1) linked to A1-B1-C1(Sheet 2)
A2-B2-C2(Sheet 1) linked to D1-E1-F1(Sheet 2)
A3-B3-C3(Sheet 1) linked to G1-H1-I1(Sheet 2)

thanks
--
6-West

Linking cell ranges between rows and columns
 

In Sheet2!A1:

=OFFSET(Sheet1!A1,INT((COLUMN()-COLUMN($A$1))/3),MOD((COLUMN()-
COLUMN($A$1)),3))

Copy to the right.

HTH
Kostis Vezerides

On Jul 3, 5:12 pm, sixwest wrote:
I'm OK with linking and transposing cells but what I need to do is to link
ranges. EXAMPLE: I have multiple cell ranges in Sheet 1 :

A1-B1-C1
A2-B2-C2
A3-B3-C3

Is there a direct way to link those row ranges in Sheet 1 with corresponding
column ranges in Sheet 2?:

A1-B1-C1(Sheet 1) linked to A1-B1-C1(Sheet 2)
A2-B2-C2(Sheet 1) linked to D1-E1-F1(Sheet 2)
A3-B3-C3(Sheet 1) linked to G1-H1-I1(Sheet 2)

thanks
--
6-West