I have a spreadsheet containing data in this format:
0 -390 0:00
-390 -390 1:00
-390 -390 2:00
-390 -390 3:00
-390 -390 4:00
-390 -140 5:00
-140 -140 6:00
-140 -140 7:00
.
.
.
.
.
.
-140 -100 23:00
-100 0 24:00
I need to print all the lines where the value of the second column changes to a different number. I need to print the first line by default. Then, I would need to print the line when the -390 changes to -140 and the lines when the -140 becomes -100. More explicitly, I would need to print the contents of the line with -140. How would I do this? In addition, once the text file is created, is there a way to programmatically allow the user to view the file? I hope my explanation is clear. Any help would be appreciated. I am new to Excel VBA programming.
Bookmarks