Macro to create new worksheets from csv file

[Les]

Please help
This is a few lines of a csv file that I have. I have it
open in an Excel workbook. I need to write/record a macro
that creates a new worksheet and cuts and pastes the data
into them at every line that contains an 'R' on the left
hand side. The amount of rows that contain data after
the 'R' row are variable throughout the file.
Thank you.

H 11/12/2003 08:00:12
R 7926 1601 N B 11/12/2003
11/12/2003 10:15
L BX10A T10 2 18 6
L BX10A T10 5 71 29
L T20 43 63 22
L T21 BM 9 1
L T21 MB 6 1
L T21 11 17 3
L T21 13 14 2
L T21 14 7 2
L T27 87 17 7
L T27 88 19 8
L T30 74 7 7
L T30 76 2 2
L T32 47 20 16
L T33 16 14 13
L T33 19 17 15
L T33 22 3 3
L T38 AT 8 6
L T38 BT 1 1
L T82 73 16 12
L T83 71 2 2
L T83 83 3 1
L T86 12 6 6
R 7927 1494 N H 11/12/2003
11/12/2003 10:20
L T16 301 1 1
L T17 302 6 6
L T18 201 11 11
L T25 204 2 2
L T28 203 31 17
L T30 107 30 22
L T32 304 20 19
L T37 206 27 24
L T37 208 25 20
L T37 209 7 7
L T38 105 71 32
L T41 104 212 60
L T57 205 13 13
L T57 207 7 7
L T81 200 1 1
L T86 300 2 2
L T93 306 104 54
R 7927 1494 N B 11/12/2003
11/12/2003 10:20
L BX10A T10 2 9 6
L BX10A T10 5 35 23
L BX21A T21 20 76 37

 

[Don Guillett]

I replied again to your original post. You should stay in the original
thread instead of starting over again.