desantech
06-29-2018, 09:48 AM
Hello
I didnt search for it yet a lot, but till now I couldnt find anything. My question is:
1. I have a lot of rows with data in 10 different columns (or more), like width, height, color etc but not all cells are filled with info
2. I would like to display all those columns in a listbox that have cell value in a range:
(if my selected range is blue text, then all those yellow columns are displayed even if in range there are some empty cells)
D
d1
OD
L
l1
B
b1
b2
H
h1
h2
R
alpha
t1
W
V
G
CHF pro Stk.
224
153
35.5
60
1740
2'020.00
274
178
48
60
2440
2'190.00
50
67
92
45
430
496.00
100
67
92
45
860
820.00
246
140.6
67
92
45
156.6
90
1580
2'060.00
45
45
45
50
194.00
so it would look like this:
L
l1
B
H
h1
R
alpha
G
CHF pro Stk.
50
67
92
45
430
496.00
100
67
92
45
860
820.00
246
140.6
67
92
45
156.6
90
1580
2'060.00
Thanks a lot
Kind regards
I didnt search for it yet a lot, but till now I couldnt find anything. My question is:
1. I have a lot of rows with data in 10 different columns (or more), like width, height, color etc but not all cells are filled with info
2. I would like to display all those columns in a listbox that have cell value in a range:
(if my selected range is blue text, then all those yellow columns are displayed even if in range there are some empty cells)
D
d1
OD
L
l1
B
b1
b2
H
h1
h2
R
alpha
t1
W
V
G
CHF pro Stk.
224
153
35.5
60
1740
2'020.00
274
178
48
60
2440
2'190.00
50
67
92
45
430
496.00
100
67
92
45
860
820.00
246
140.6
67
92
45
156.6
90
1580
2'060.00
45
45
45
50
194.00
so it would look like this:
L
l1
B
H
h1
R
alpha
G
CHF pro Stk.
50
67
92
45
430
496.00
100
67
92
45
860
820.00
246
140.6
67
92
45
156.6
90
1580
2'060.00
Thanks a lot
Kind regards