Hi Guys,
I have a short question. I’ve got a mega excel file containg over 100 names.all the rows are grouped together and contain subtotals. What i would like to achieve is create an excel file containing all the rows per group (lets say row 2-40 contain info for group 1 and row 41-80 the next group (the groups are not static so hardcoding the rows will not work). any ideas?