this is the code i have so far:
Application.ScreenUpdating = False
Dim copySheet As Worksheet
Dim pasteSheet As Worksheet
Set copySheet = Worksheets("BDO Pipeline")
Set pasteSheet = Worksheets("UW Pipeline")
copySheet.Range("E3:H3").Copy
pasteSheet.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues
Application.CutCopyMode = False
Application.ScreenUpdating = True
Sheets("UW Pipeline").Select
I delete data from the "UW Pipeline" regularly and would like to have the data that is copied from the "BDO Pipeline" and pasted into "UW Pipeline" to past in the next available row that is open no matter if it is above or below other data. thanks for the help in advance and let me know if you have any other questions.
Application.ScreenUpdating = False
Dim copySheet As Worksheet
Dim pasteSheet As Worksheet
Set copySheet = Worksheets("BDO Pipeline")
Set pasteSheet = Worksheets("UW Pipeline")
copySheet.Range("E3:H3").Copy
pasteSheet.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues
Application.CutCopyMode = False
Application.ScreenUpdating = True
Sheets("UW Pipeline").Select
I delete data from the "UW Pipeline" regularly and would like to have the data that is copied from the "BDO Pipeline" and pasted into "UW Pipeline" to past in the next available row that is open no matter if it is above or below other data. thanks for the help in advance and let me know if you have any other questions.