Forum Discussion
Excel VBA adding titles to Subtotalled Information under second view in First Visible Cell
In my excel file, I use a subtotal to sort large quantity of information, Normally, when doing this manually, I select the second view then in the first row, use = and the column above. For e...
You could try formatting the whole data set as a table whereby formulas would automatically be entered into the rows below (assuming that the values brought down from row 14 are formulas). Select entire data range (select any cell within data and use shortcut Ctrl+A, then use shortcut Ctrl+T to format as a table - check the box for 'My Data Has Headers'). Hope this helps.