Trying to auto sort and set the print area for a report

[Prill]

Hello everyone!

So I have a new task and I'm sure there is a way to automate it some. So at the end of each week I need to make a report that sorts based on the salesperson and date. So I would like a macro that would seperate each of column F into groups and then seperates It by date (ascending). Can anyone help me accomplish this? Or how do I do this? While I am sure there is a way based on filters and copying and pasting, it seems like a macro would make it go a lot quicker. At the end of the macro it should set the print area to the sorted lists. I included a before and after that should demonstrate what I am trying to accomplish.

Any help is appreciated. Thanks!

[Marc L]

Hi !

As a tip : using a filter directly on the data you do not ever need to create any 'after' range, just print the filtered data …

[Prill]

That does work and I have done that. The after area was shown to represent what I was wanting it to look like. Using the sort function which is easy with the recorder does order it the right way, but I would like to have it insert two rows between each initial (DF->JK) (JK->KM) (KM->LM). Then be able to select the top left cell (one above the top quote number for each line) and write the name based on an if function. I'm not sure how to tell it to go to that initial and then write the if function.

So for example in the after area of the worksheet I uploaded I would like I3 to write "if K4 = "KM" then write "Name here". Then do that for each of the remaining.