Sort by date after calculation is done

[zc5]

Hi all,

I feel like I am missing a very simple solution on sorting but I can't seem to figure it out. I have a sheet that calculates a whole bunch of stuff using references from other sheets. Someone here kindly helped me build it and I did some tweaks on it. The main issue I am having is I can't figure out how to sort the entries on the "Summary" sheet so that all the dates are grouped together where the newest dates are at the top. For example it looks like this:

Person A - 11/20/2016
Person A - 11/13/2016
Person A - 11/6/2016
Person B - 11/20/2016
Person B - 11/13/2016
Person B - 10/30/2016
Person C - 11/13/2016
Person C - 10/30/2016

Instead I want it to look like this:

Person A - 11/20/2016
Person B - 11/20/2016
Person A - 11/13/2016
Person B - 11/13/2016
Person C - 11/13/2016
Person A - 11/6/2016
Person B - 11/6/2016
..........

I have attached the sheet, appreciate the help!

[JieJenn]

Unless your summary report is not generated using formula, otherwise, it is almost impossible to sort your report. One solution is to copy your report to a separate worksheet as regular value (or text whatever you want to call it), then do the sorting.

[zc5]

Is there a way to have it automatically copy it to a new sheet as "regular values" and do sorting? If you could let me know the steps to take that would be highly appreciated. Thanks!

[JieJenn]

You will have to use a macro.

Give this code a try. (You will have to fix your formula in Column A on your summary worksheet to address the error first as showing in the attachment)

Please Login or Register  to view this content.