Thank you in advance for any help you can give me.
I have the following information extracted from a very old program:
<TBODY>
</TBODY><COLGROUP><COL span=2><COL><COL><COL></COLGROUP>
I need to get the data to look like this. I have been doing it cut and paste style and it is very time consuming. Is there a macro I can use to make it easier?
<TBODY>
</TBODY><COLGROUP><COL span=2><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP>
I have the following information extracted from a very old program:
Bob</SPAN> | Eating</SPAN> | Berries Verified</SPAN> | February 28, 2014 7:47:24 AM CST</SPAN> |
Bob</SPAN> | Eating</SPAN> | Apples Submitted</SPAN> | October 10, 2012 3:31:18 PM CDT</SPAN> |
Bob</SPAN> | Eating</SPAN> | Oranges Approved</SPAN> | April 5, 2013 5:48:11 PM CDT</SPAN> |
Bob</SPAN> | Eating</SPAN> | Berries Deploy</SPAN> | January 29, 2014 9:59:14 AM CST</SPAN> |
Bob</SPAN> | Eating</SPAN> | Apples Approved</SPAN> | January 9, 2013 1:37:54 PM CST</SPAN> |
Bob</SPAN> | Eating</SPAN> | Oranges Review</SPAN> | January 15, 2013 11:31:41 AM CST</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL span=2><COL><COL><COL></COLGROUP>
I need to get the data to look like this. I have been doing it cut and paste style and it is very time consuming. Is there a macro I can use to make it easier?
Name</SPAN> | Subject</SPAN> | Apples Submitted</SPAN> | Apples Approved</SPAN> | Oranges Review</SPAN> | Oranges Approved</SPAN> | Grapes Start</SPAN> | Grapes Completed</SPAN> | Lemons Rev</SPAN> | Lemons Baseline</SPAN> | Berries Deploy</SPAN> | Berries Verified</SPAN> |
Bob</SPAN> | Eating</SPAN> | 10-Oct-12</SPAN> | 9-Jan-13</SPAN> | 15-Jan-13</SPAN> | 5-Apr-13</SPAN> | 29-Jan-14</SPAN> | 28-Feb-14</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL span=2><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP>