Write basic script in google sheets for exporting to a new worksheet -- 2

We require a simple Google Sheets script to be written. We have a copy of the VBR macro we used to use in Excel and simply require the same functionality in Google Sheets. Please see origonal Excel script below: Sub NewPortfolio_Button1_Click() Dim i As Integer [login to view URL] = False Sheets("New Portfolio").Copy [login to view URL] [login to view URL] [login to view URL] Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False Columns("S:AZ").Select [login to view URL] Shift:=xlToLeft [login to view URL](Array("Button 1")).Select [login to view URL] Cells(1, 1).Select For i = 50 To 200 If Cells(i, 1) = "DELETE" Then Rows(i & ":" & i).Delete i = i - 1 End If Next i End Sub On each of the three tabs (Current Portfolio, Rebalance and New Portfolio) we need to be able to extract the values to a new workbook, delete blank spaces and keep conditional formatting (Cell Colours) when we sort the data. This used to be done via a button which ran a macro on each of the three pages. This should only be a quick job for the right person.