Importing CSVs into Pre-Formatted Data Sheet - Start and Stop Macro

[cappiccolo]

I have a .csv where (once text to columns and bold for emphasis, to try to make it easier to see) it's formatted like this. I need to be able to import this into a template so that I can work with it - new files come through every day.

I found a super useful thread with a response from Trevor_S about this kind of problem with a macro, and I think this could work for me. My query is kind of a next step, I guess. I'm wondering how to tell a macro when to stop, because it needs to stop before the last row in this instance. For example if I want to take the data from rows 4 - 12, rather than from 4 to the end, how would I do that? Particularly as there are three instances of RECORD_TYPE.

 

[XLfriend777]

Hi *cappiccolo - Welcome to the forum. The code below starts at Row 4 and selects Row 4, then 5 through 12 sequentially. You may be able to modify this for your needs. Hope this helps get you started.

Sub Rows4to12()
Dim i As Integer
i = 4

    While i < 13
     Cells(i, 1).EntireRow.Select
     i = i + 1
    Wend

End Sub

 

[cappiccolo]

Hi *cappiccolo - Welcome to the forum. The code below starts at Row 4 and selects Row 4, then 5 through 12 sequentially. You may be able to modify this for your needs. Hope this helps get you started.

Sub Rows4to12()
Dim i As Integer
i = 4

    While i < 13
     Cells(i, 1).EntireRow.Select
     i = i + 1
    Wend

End Sub

Thanks, goesr! That does indeed get me closer. Much appreciated.