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. A3 is the header and E3 is the value. It will pick up the values on Sheet1 on line 2 (green, 6, 76, 2).
Sheet 1
A,B,C,D;E
A3,E3
Green,6,32,11
Sheet 2
A,B,C,D;E
Red,2,3,7,8
Yellow,4,5,9,6
Green,2,1,1,6
Blue,3,7,9,8
Sheet 3
A,B,C,D;E
Red,2,3,7,8
Yellow,4,5,9,6
Green,2,1,22,32
Blue,3,7,9,8
Sheet 4
A,B,C,D;E
Red,2,3,7,8
Yellow,4,5,9,6
Green,2,1,1,11
Blue,3,7,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. A3 is the header and E3 is the value. It will pick up the values on Sheet1 on line 2 (green, 6, 76, 2).
Sheet 1
A,B,C,D;E
A3,E3
Green,6,32,11
Sheet 2
A,B,C,D;E
Red,2,3,7,8
Yellow,4,5,9,6
Green,2,1,1,6
Blue,3,7,9,8
Sheet 3
A,B,C,D;E
Red,2,3,7,8
Yellow,4,5,9,6
Green,2,1,22,32
Blue,3,7,9,8
Sheet 4
A,B,C,D;E
Red,2,3,7,8
Yellow,4,5,9,6
Green,2,1,1,11
Blue,3,7,9,8
Thank you,
Matti