scoutzilla
New Member
- Joined
- Aug 7, 2012
- Messages
- 7
Greetings all and Happy Holidays.
My problem seems so simple I thought I could come up with a solution on my own, but after working on this for days, I ask for help.
I import .txt data file then need to find where where my data starts (TIME), the number of columns, the number of rows, copy all and paste to Sheet "Clean Data". I can't seem to come up with a Macro that will do this. Here is a sample of what my data might look like:
<colgroup><col><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>Cheers!
My problem seems so simple I thought I could come up with a solution on my own, but after working on this for days, I ask for help.
I import .txt data file then need to find where where my data starts (TIME), the number of columns, the number of rows, copy all and paste to Sheet "Clean Data". I can't seem to come up with a Macro that will do this. Here is a sample of what my data might look like:
Number of Rows | ||||||||||||||
Above | ||||||||||||||
TIME | ||||||||||||||
Changes | ||||||||||||||
TIME | Range | of | data | would | start | with | TIME | then | end | with | empty | cells | ||
0 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | ||
1 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | ||
2 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | ||
3 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | ||
4 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | ||
5 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | ||
<colgroup><col><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>