Dear Excel gurus,
I have a workbook with data sections separated by an empty row, where I'd need to summarize some data to new columns, I have attached a workbook with two worksheets.
First sheet contains the data how it is currently, and the second worksheet is an example how the macro should summarize the desired data from columns D & E.
The rows per section vary from 3-6.
Please see attach example
example.xlsx
Edit: First sheet does not have the extra columns for generated numerical data, don't get confused by this![]()
Bookmarks