formula for merged cells

[shahsavand]

hi all i have a column with 15 rows merged cells and i need a formula to link each 15 merged cell from other sheets of single cell.
thanks

 

[Snakehips]

@shahsavand it's not entirely clear to me what you are wanting.

If you are wanting Sheet1A1: A? to appear in a series of 15 rows deep merged cells then maybe like below.

Picking Teams.xlsm
	A
1	From Sheet1 A1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16	From Sheet1 A2
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Test (2)

Cell Formulas
Range	Formula
A1,A16	A1	=OFFSET(Sheet1!A1,-QUOTIENT(ROW(),15)*14,)

If that is not what you require then please try and clarify.
Also, it will help someone to help you if you could clarify what version of Excel you are using.

 

[shahsavand]

@shahsavand it's not entirely clear to me what you are wanting.

If you are wanting Sheet1A1: A? to appear in a series of 15 rows deep merged cells then maybe like below.

Picking Teams.xlsm
	A
1	From Sheet1 A1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16	From Sheet1 A2
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Test (2)

Cell Formulas
Range	Formula
A1,A16	A1	=OFFSET(Sheet1!A1,-QUOTIENT(ROW(),15)*14,)

If that is not what you require then please try and clarify.
Also, it will help someone to help you if you could clarify what version of Excel you are using.

thank you brother. it worked properly . also i found another solution with =INDEX(Sheet2!$A$1:$A$203,COUNTA(A$2:A2))