I am looking for helping with the following. I am getting a data dump from a program that outputs in the following format
Technician: Tech Name
Order# Description Date Start End Duration
408280 Labour 11/25/2006 15:00 19:30 4.50
411505 Contract 11/27/2006 12:15 13:35 1.33
411505 Contract 11/27/2006 13:35 14:35 1.00
406740 Project 11/27/2006 9:11 9:11 0.00
MANUAL Vacation 11/28/2006 8:30 16:00 7.50
I run a macro to remove the blank lines but what I would like is to run a single macro that could remove the blank lines and rearrange the data to look like this:
Tech Name
11/25/2006 15:00 19:30 4.50 408280
11/26/2006
11/27/2006 9:11 9:11 0.00 406740 12:15 13:35 1.33 411505 13:35 14:35 1.00 411505
11/28/2006 8:30 16:00 7.50 MANUAL
So far I am doing this manually but it consumes a fair amount of time as there are multiple techs, each of them is separated by two rows:
Total
Order #
Would anybody be able to help automate this process?
Thanks in advance for any assistance.
--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from
http://www.shemes.com/ =-