Hi, Hopefully someone can point me in the right direction on how to structure a code to do the following (i'll try explain best i can)
below is an example of the kind of data im working with.. i've tried for / nexts loops within loops, creating variables to + 1 on rows, and all kinds of stuff but im stuggling and it never comes out as planned
a b c d
1 header1 header2 header3 header 4
2 green banana one two
3 green banana two three
4 green orange three four
5 green orange five six
6 red apple four one
7 red pear one two
i want to ...
-add color, next row down add the headers, next row - add all the data where b is the same (banana).. then new headers but under same color, then the next data in b (orange) with same color(green) then leave a row and start the new color. (as shown below)
a b c
1 Green
2 header2 header3 header4
3 banana one two
4 banana two three
5 header 2 header3 header4
6 orange three four
7 orange five six
8
9 red
10 header2 header3 header4
11 apple four one
12 pear one two
any assitance is appriciated
Thanks
below is an example of the kind of data im working with.. i've tried for / nexts loops within loops, creating variables to + 1 on rows, and all kinds of stuff but im stuggling and it never comes out as planned
a b c d
1 header1 header2 header3 header 4
2 green banana one two
3 green banana two three
4 green orange three four
5 green orange five six
6 red apple four one
7 red pear one two
i want to ...
-add color, next row down add the headers, next row - add all the data where b is the same (banana).. then new headers but under same color, then the next data in b (orange) with same color(green) then leave a row and start the new color. (as shown below)
a b c
1 Green
2 header2 header3 header4
3 banana one two
4 banana two three
5 header 2 header3 header4
6 orange three four
7 orange five six
8
9 red
10 header2 header3 header4
11 apple four one
12 pear one two
any assitance is appriciated
Thanks
Last edited:
