I have the following Macro below which takes a few mins to run (number of rows only 292 and up to col O)
Sub Delete_Stock_Transferred_toanotherBranch()
With Sheets(2)
Dim lr As Long
Dim i As Long
lr = .Cells(Rows.Count, "O").End(xlUp).Row
For i = lr To 2 Step -1
If .Cells(i...