Linking cell ranges between rows and columns


S

sixwest

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
 
Ad

Advertisements

V

vezerid

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top