I have a spreadsheet that, once complete, I run "Groups" to select data by department and once that is done I need to select and email each section i.e. Row 2 to 20 for the first row up to the row below the bottom to capture the "Totals" row. Unfortunately, there are a few that only have one row plus the total. Therefore the rows could be one row to 40 or 50 rows as each group/section vary.
What I need the macro to do is start on the first row, go down to the last row of that section, drop down one more row to capture the Totals row and then select the entire rows within that section.
Thanks.
What I need the macro to do is start on the first row, go down to the last row of that section, drop down one more row to capture the Totals row and then select the entire rows within that section.
Thanks.
