I can easily achieve the same result with a pivot table by dragging the Salesperson field into Rows and the Sales field into Values. It will also be nicely formatted. However, if I change anything in ...

To do that, open the Macros window, select the macro, and click Options. Under Shortcut key, press the key to use with Ctrl —I chose Ctrl + J —and click OK. When choosing the key, just make sure it ...