Hi, I want to create an Excel sheet for a lot of dealers, consisting of two spread sheets - one for each dealer called Dealership and one with graphics. I excluded the code for the graphics, because this part of the Excel is formatted the way I want it to. On the dealership sheet, I want to see some sales figures for the whole dealer and beneath it by salesperson. The code I use is attached and the result is in "test_print_eng.xls". The thing that I want to change is that the name of the second sales person is very close to the table of the first sales person. Is there any way that I can use styles or any other method to get more space in between the table and the header of the second sales person? In order to make the Excel look prettier - see "test_print_eng - wished results" (either aligned left or centered, is fine for me). I searched the web but I didn't find something on styles and the by statement in the proc print. I know that another solution would be to generate a table for each sales person of a dealer, but I would like to use proc print and by to do the trick. Best regards, Michael
... View more