Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Data from Rows to Columns | Excel Discussion (Misc queries) | |||
Linking data from Rows to columns in seperate worksheets | Excel Worksheet Functions | |||
linking multiple roles (rows) to a user (cell) | Excel Discussion (Misc queries) | |||
Count rows that match criteria in 2 different column cell ranges | New Users to Excel | |||
Linking a cell to update when rows added | Excel Discussion (Misc queries) |