I have a formula in E4 in Sheet Summary in same row where account KX-1081 appears in COL A which is generated by VBA
I would like to text and formula to always be in the same row where KX-1081 appears in Col A on workbook Check Balance KX-1081.xlsm
Sub Formula()
With Sheets("Sheet1")...