Separate Groups

Free download

Simply press Ctrl+q after opening the file; this macro visualize the spreadsheet based on groups in column D.

If you are not familiar with macros, not the wisest but an easy way is to download this file copy your data in the file and then press ctrl + q.

You may need to enable macros if this doesn’t work.

PaintGroups