HI, I've got a macro that currently pulls in data from another system and displays each piece of data in a separate column.
Code I have currently working to paste to next column is as follows.
I'd like to display the captured data to the next row instead of the next column.
Dim i As Long
Dim xlsheet As Excel.Worksheet
Set xlsheet = Worksheets("RESULTS")
For i = 2 To xlsheet.Range("A65536").End(xlUp).Row
For each piece of data captured to be entered into each column the code is as follows
xlsheet.Cells(i, 2) =REDACTED
xlsheet.Cells(i, 3) =REDACTED
xlsheet.Cells(i, 4) =REDACTED
Code I have currently working to paste to next column is as follows.
I'd like to display the captured data to the next row instead of the next column.
Dim i As Long
Dim xlsheet As Excel.Worksheet
Set xlsheet = Worksheets("RESULTS")
For i = 2 To xlsheet.Range("A65536").End(xlUp).Row
For each piece of data captured to be entered into each column the code is as follows
xlsheet.Cells(i, 2) =REDACTED
xlsheet.Cells(i, 3) =REDACTED
xlsheet.Cells(i, 4) =REDACTED