Excuse my naivety, but any assistance would be greatly appreciated. Basically I have two columns of data within a range that I want to paste into two empty columns within a dataset, I've used the following code for a start, but it lacks the ability to only select filled sells from the DealTemplate and won't paste in the empty rows in the DealList.sheet. I've attached an example sheet. I've had this macro in my sheets before, but for the life of me I can't remember the code that tweaks it to do what I need. Thanks in advance for any help!!!!
Sub CopyPaste_Click()
Application.ScreenUpdating = False
Dim copySheet As Worksheet
Dim pasteSheet As Worksheet
Set copySheet = Worksheets("DealTemplate")
Set pasteSheet = Worksheets("DealList")
copySheet.Range("y5:z49").Copy
pasteSheet.Cells(Rows.Count, 1).End(xlUp).Offset(1, 1).PasteSpecial xlPasteValues
Application.CutCopyMode = False
Application.ScreenUpdating = True
End Sub
Bookmarks