I've tried searching for a solution to this, but can't quite seem to find a right one.
I've a worksheet with many rows of data, but some of the rows I would like to delete via a macro if possible.
Unfortunately, colo's utility didn't work for me so I can't paste a copy of the work sheet, but it looks like following:
row1titles).....a/c....fltin....timein....fltout....timeout
row2data)......201..100...08:00.....101....08:30
row3data)......201............................101....08:30
row3data)......202............................102....09:00
row4data)......203..103...09:30.....104....10:00
row5data)......203............................104....10:00
row5data)......203..105...10:30...........................
I get this data from a text file and is sorted by fltout + flitin columns. I need to be able to delete row 3 and row 5. (There are about 100 rows for this data.)
I need a macro as this data changes everyday and it would definately make my job easier as I currently have to enter this data by hand. I have recorded a macro to get the data in above format but now I'm just a step away from the desired fromat.
Thanks in advance for all your help!
I've a worksheet with many rows of data, but some of the rows I would like to delete via a macro if possible.
Unfortunately, colo's utility didn't work for me so I can't paste a copy of the work sheet, but it looks like following:
row1titles).....a/c....fltin....timein....fltout....timeout
row2data)......201..100...08:00.....101....08:30
row3data)......201............................101....08:30
row3data)......202............................102....09:00
row4data)......203..103...09:30.....104....10:00
row5data)......203............................104....10:00
row5data)......203..105...10:30...........................
I get this data from a text file and is sorted by fltout + flitin columns. I need to be able to delete row 3 and row 5. (There are about 100 rows for this data.)
I need a macro as this data changes everyday and it would definately make my job easier as I currently have to enter this data by hand. I have recorded a macro to get the data in above format but now I'm just a step away from the desired fromat.
Thanks in advance for all your help!