Teatimedgg
09-27-2017, 04:38 PM
Hey Everyone,
Newby here! I have a multiple columns of data but i want to insert a header line (1st line -range A2.H2) when the word Dog-A changes in Column C i want this to continue until the end of data in column c
Example:
H
ABC company
Header
12345
123
12345
0
12
L
ABC company
Dog
***x
Unit
1
L
ABC company
Dog
***x
Unit
1
19.03
L
ABC company
Dog-A
***x
Unit
1
200
L
ABC company
Cat
***x
Unit
1
70
L
ABC company
Cat
***x
Unit
1
15000
Any help would be appreciated!!! Thank you!
Newby here! I have a multiple columns of data but i want to insert a header line (1st line -range A2.H2) when the word Dog-A changes in Column C i want this to continue until the end of data in column c
Example:
H
ABC company
Header
12345
123
12345
0
12
L
ABC company
Dog
***x
Unit
1
L
ABC company
Dog
***x
Unit
1
19.03
L
ABC company
Dog-A
***x
Unit
1
200
L
ABC company
Cat
***x
Unit
1
70
L
ABC company
Cat
***x
Unit
1
15000
Any help would be appreciated!!! Thank you!