Look in range to find last row then import cell from another sheet in cell on that last row

[bdouglas1011]

I have to sheet call it sheet1 & Sheet2.
Sheet1 has Cells B17 & B18 I need to place onto sheet 2.
Sheet2 has range with data in it D17:D367 - find the last row with data in that range (It changes daily) and on that row
Place Sheet(1) (B17) in (K) column of last row on Sheet2
Place Sheet(1) (B18) in (L) column of last row on Sheet2

Hope I explained it OK

 

[bdouglas1011]

I have tried to do almost the same as my earlier post but it did not execute properly.
it is grabbing the data and putting it on the correct sheet but not on the correct row unless I run the macro twice.
the first time I run it the data gets inputted into row(14) not the last row in the range it was supposed to select but if I run it again it does put it in the correct last row.

 Dim RunNo   
    Surveys.Range("D368").End(xlUp).Select
    i = ActiveCell.row
    RunNo = Sheet27.Range("B11").Value
    cells(i, 2).Value = RunNo

 

[bdouglas1011]

solution that works for now

 Range("D367").End(xlUp).Select
                        b = ActiveCell.row
                        AB = Sheet27.Range("B17").Value
                        LR = Sheet27.Range("B18").Value
                        SS = Sheet27.Range("B12").Value
                        
                        cells(b, 11).Value = AB
                        cells(b, 12).Value = LR
                        cells(b, 21).Value = SS