If cell B is not empty, drag down formulas in columns A-N

[MMR]

Hi there,
I was hoping you could help with the following:

• I have an Excel worksheet, with formula data within columns A-N
• I have IDs/Names in column B - sometimes there are more Names and sometimes there may be less (I paste in data daily via an already existing Macro)
• On the days where there are less, I would like a Macro to look at column B, go down all the way to the bottom to find the last cell containing a name/ID (e.g. cell B322); if this is not blank (i.e. cell in column B is populated with a name/ID), then drag down the formulas in columns A and C-N accordingly to fill in the rest of the data for that ID/Name
• As an example, on the other hand, on days where there is less data, I have written a short Macro to identify the bottom of column B with populated data, and if this is blank, to delete the whole rows (to remove the excess formulas that are not needed from previous day) - the code below is working fine (so I just need a macro for the alternative option above):

Worksheets("Portfolio").Select
Range("B2:B15000").Select
Selection.SpecialCells(xlCellTypeBlanks).EntireRow.Delete

 

[Fluff]

How about

Sub mmr()
   Dim LrA As Long, LrB As Long
   
   LrA = Range("A" & Rows.Count).End(xlUp).Row
   LrB = Range("B" & Rows.Count).End(xlUp).Row
   If LrA < LrB Then
      Range("A" & LrA).Resize(LrB - LrA + 1).FillDown
      Range("C" & LrA).Resize(LrB - LrA + 1, 12).FillDown
   ElseIf LrA > LrB Then
      Range("A" & LrB + 1).Resize(LrA - LrB, 14).ClearContents
   End If
End Sub