Copy from one cell and paste to another sheet based on length of another column

Closed
Ski4q Posts 2 Registration date Tuesday 20 August 2019 Status Member Last seen 21 August 2019 - 20 Aug 2019 à 05:28
 Blocked Profile - 21 Aug 2019 à 07:34
Hi I am using the code below to copy and paste from one column to another based on cells containing data in column A, what I need to do it copy data from a single cell (J2) in sheet1 and paste into next empty cell in column A on sheet 2 based length column B (cells containing data)

Sub FillDown()
Dim LastRow As Long

With ActiveSheet

LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
.Range("D2").AutoFill .Range("D2").Resize(LastRow)
End With
End Sub

2 responses

Blocked Profile
20 Aug 2019 à 07:17
Record a macro! Edit the macro to see what steps the macro takes to accomplish the task. Modify the macro to fit your dynamic needs!
Ski4q Posts 2 Registration date Tuesday 20 August 2019 Status Member Last seen 21 August 2019
21 Aug 2019 à 03:00
Thanks Mark, I did try doing it with a macro but was getting nowhere so tried the code above which did part of what I was after but I was unable to target the single cell with the data that I wanted to copy down
Blocked Profile
21 Aug 2019 à 07:34
Sorry looking at the macro didnt help. It is the easiest way!