Forum Discussion
Excel Dynamic ranges?
I have a workbook with a worksheet for each month of the year plus a summary sheet for the whole year. Each monthly worksheet has 400 to 600 rows each representing a transaction/sale. I sort the rows...
You mentioned
I sort the rows based on who provided the service
That means in each row you have the field which indicates who made the transaction, correct? If so it's not clear why do you need Start:End to summaries. Or how source data looks like?