![]()
Sub Macro() 'Find Last used Column in Row 58 LC = Cells(58, Columns.Count).End(xlToLeft).Column 'Find Last Column with Actual in Formula For Col = LC To 1 Step -1 T = Cells(58, Col).Formula If InStr(T, "Actual") > 0 Then Exit For Next 'Put Formula in the next column Cells(58, Col + 1).Select Selection.Formula = "='Actuals 2016'!" & Cells(51, Col).Address With Selection.Interior .Pattern = xlSolid .PatternColorIndex = xlAutomatic .ThemeColor = xlThemeColorDark1 .TintAndShade = 0 .PatternTintAndShade = 0 End With End Sub
Bookmarks