title: VBA- Import Multiple CSV to a Sheet, Remove Certain Rows/Columns
body: <p>I am completely new to VBA, but I have CSV files(same format for all of them), and I want to import them to a single sheet on Excel. I was able to read the CSV file according to this code:</p>
  
  <pre><code>Sub R_AnalysisMerger()
  Dim WSA As Worksheet
  Dim bookList As Workbook
  Dim SelectedFiles() As Variant
  Dim NFile As Long
  Dim FileName As String
  Dim ws As Worksheet, vDB As Variant, rngT As Range
  
  Application.ScreenUpdating = False
  
  'Selects the CSV files as SELECTED FILES
  Set ws = ThisWorkbook.Sheets(1)
  ws.UsedRange.Clear  'Clears current worksheet
  SelectedFiles = Application.GetOpenFilename(filefilter:="Excel Files (*.csv*), *.csv*", MultiSelect:=True) 'Selects csv files
  
  
  For NFile = LBound(SelectedFiles) To UBound(SelectedFiles)
      FileName = SelectedFiles(NFile)
      Set bookList = Workbooks.Open(FileName, Format:=2)
      Set WSA = bookList.Sheets(1)
      With WSA
          vDB = .UsedRange
          Set rngT = ws.Range("a" &amp; Rows.count).End(xlUp)(2)
          If rngT.Row = 2 Then Set rngT = ws.Range("A1")
          rngT.Resize(UBound(vDB, 1), UBound(vDB, 2)) = vDB
  
          bookList.Close (0)
      End With
  Next
  Application.ScreenUpdating = True
  ws.Range("A1").Select
  </code></pre>
  
  <p>But I have additional requirements:
  Skip the first column.
  Skip the first four rows.
  Remove a certain String from each word in the fifth row.</p>
  
  <p>Im used to java, and usually I would read each line with a "for" loop and set "if" statements to skip the first row and four columns and remove the string from each string if it was present.</p>
  
  <p>I don't know how to do this with this code. From what I understand it just copies the whole CSV file into the sheet? </p>