M
Matti Koski
Hi,
How can I create following function which collects the information from
sheets 2-4 to sheet1? After I have activated Sheets 2, 3 and 4, I will give
two parameters on Sheet1. Cell A3 is the header and cell E3 is the value
that I like to collect. After giving the 2 parameters, it will pick up the
values on Sheet1 on line 2 (green, 6, 76, 2).
Sheet1
Sheet2
Sheet3
Sheet4
A
B
C
D
E
A3
E3
green
6
76
2
A
B
C
D
E
red
2
1
7
8
yellow
4
5
9
6
green
2
1
1
6
blue
3
7
9
8
A
B
C
D
E
red
4
71
9
7
yellow
4
5
9
66
green
2
3
1
76
blue
3
7
1
7
A
B
C
D
E
red
2
1
6
8
yellow
4
99
7
6
green
2
1
1
2
blue
3
8
9
8
Thank You,
Matti
How can I create following function which collects the information from
sheets 2-4 to sheet1? After I have activated Sheets 2, 3 and 4, I will give
two parameters on Sheet1. Cell A3 is the header and cell E3 is the value
that I like to collect. After giving the 2 parameters, it will pick up the
values on Sheet1 on line 2 (green, 6, 76, 2).
Sheet1
Sheet2
Sheet3
Sheet4
A
B
C
D
E
A3
E3
green
6
76
2
A
B
C
D
E
red
2
1
7
8
yellow
4
5
9
6
green
2
1
1
6
blue
3
7
9
8
A
B
C
D
E
red
4
71
9
7
yellow
4
5
9
66
green
2
3
1
76
blue
3
7
1
7
A
B
C
D
E
red
2
1
6
8
yellow
4
99
7
6
green
2
1
1
2
blue
3
8
9
8
Thank You,
Matti