sorry it is not clear what are going to "look up". you want the rows in rows 35 and 36 in thes sheet "live VWAP" is to be copied in the sheet Master data in THE FIRSTS AVAILABLE ROW.
If this is what you want
Sub test()
Application.DisplayAlerts = False
With Worksheets("live VWAP")
.Range("A35:A36").EntireRow.Copy
With Worksheets("master data")
.Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).PasteSpecial
End With
End With
Application.DisplayAlerts = True
End Sub
But this is only copying two rows from one sheet to another sheet. This is not repeated operation. Then why do you need a macro . why not manually copy?
Bookmarks