UDF Logic for Changing Signal

[sajeel]

I am currently testing a trading platform provided by bloomberg. However it currently doesnt have the ability to continously execute orders. In sheet named Signal, Cell B2 is dynamic and can change any time to "BUY","SELL" or "EXIT". Each time this cell changes, Sheet named Execution, the last row in the sheet needs to be copied and dragged one row lower with all formula's within the cells. Also Cells in Column E( Under heading Side) must be the same as Signal in Cell B2 in the signal sheet. So each time the Signal changes in Cell B2 (Sheet= "SIGNAL"), the last row in Sheet ="Execution" must be copy and dragged 1 row lower with Side= Cell B2 in Sheet= "Signal".

Is this possible using a UDF?

[Bob Phillips]

Private Sub Worksheet_Change(ByVal Target As Range)
Dim Lastrow As Long

    On Error GoTo ws_exit
    
    Application.EnableEvents = False
    
    With Worksheets("Execution")
    
        Lastrow = .Cells(.Rows.Count, "B").End(xlUp).Row
        .Rows(Lastrow).Copy .Cells(Lastrow + 1, "A")
        .Cells(Lastrow + 1, "E").Value2 = Target.Value
    End With
    
ws_exit:
    Application.EnableEvents = True
End Sub

This is worksheet event code, which means that it needs to be
placed in the appropriate worksheet code module, not a standard
code module. To do this, right-click on the sheet tab, select
the View Code option from the menu, and paste the code in.

[sajeel]

Thanks for that Bob. I would like to do exactly the same with the change in signal however this time instead of copying and dragging the entire last row of Sheet "Execution", I only require 2 cells in sheet "Execution" to be filled. In sheet "Signal", Cell B2 and Cell C2 need to be copied and pasted into the last empty column. i.e 1st Cell B2 from "Signal" needs to be pasted into last row of Column E of sheet "Execution" and then Cell C2 needs to be pasted into last row of Column B of sheet "Execution". This is because Coulmns C,D,F,G,H,I,J will be pre filled to infinte rows all the way down in sheet "Execution".

I have done an example highlighted in Sheet " Signal" with the same colour formats copy-pasted in Sheet "Execution".