I'm using this code to copy data from one workbook into another, with the data broken out onto separate sheets. The only thing that doesn't copy is Row 1, which has the headers. How do I copy that row onto each sheet?
Dim Lastrow As Long, LastCol As Integer, i As Long, iStart As Long, iEnd As...