VB Code to Drag Formula to Visible Rows Only : I've tried searching for this but have only ended up with a non-functioning Frankenstein sub routine. I need to:
 
-Filter Column B to Grey Cells.

-In column AB on all visible rows, set formula equal to the values in Column B.
    If a row is filtered out, I need it to remain blank.

Bonus question (because I'm a pain in the neck): I need to do some kind of loop to replicate this process in columns AC:BA as well. For example, filter Column C to grey cells, and make all visible cells in AC equal to the corresponding row in Column C.

EDIT: I was also thinking to just do a Control + Find, replace any cell where the background color is no fill, and replace with a blank or 0. I can't get that to work either, however.

Code that I have (currently I'm stuck at having selected the first visible cell in Column AB):
        

    Dim Last_Cell As Range
        Set Last_Cell = Range("A3").SpecialCells(xlLastCell)
    
      ' [Good ]Filter Column B by Color
        Range("$A$3", Last_Cell).AutoFilter Field:=2, Criteria1:=RGB(165,165,_ 
    165), Operator:=xlFilterCellColor
        
        ' [Pending ] Set all visible AB cells = same row in B
        Range("AB3").Offset(1, 0).Activate
        Do Until Selection.EntireRow.Hidden = False
        If Selection.EntireRow.Hidden = True Then
        ActiveCell.Offset(1, 0).Activate
        End If
        Loop