[Solved] Mass Copy and Paste with Mass autofill (sort of)

[bino1121]

So I wrote a quick code to copy and paste in mass
Sub MassCopyAndPaste()
With Range("A210")
.Copy Destination:=.Resize(.Rows.Count * 10)
End With
End Sub

However the next part I am struggling to do after the mass copy and paste has run I need another code that will update column A accordingly such that the Job num from sheet 2 will fill in to each in between tasks 2 and 10,000 I've attached the sheet and added a final solution sheet in the event that my explanation didn't make sense you could see what I was trying to accomplish.

 

[Ridwan]

So I wrote a quick code to copy and paste in mass
Sub MassCopyAndPaste()
With Range("A210")
.Copy Destination:=.Resize(.Rows.Count * 10)
End With
End Sub

However the next part I am struggling to do after the mass copy and paste has run I need another code that will update column A accordingly such that the Job num from sheet 2 will fill in to each in between tasks 2 and 10,000 I've attached the sheet and added a final solution sheet in the event that my explanation didn't make sense you could see what I was trying to accomplish.

Hi Bino,
Thanks for sharing problem. I have modified your code and am sharing the workbook with you in the attachment.




Download and run the code. And let us know the feedback.

Regards,
Ridwan