Creating a sorting macro

[italmike2k2]

Good morning everyone.

I have a table that is 10-12 columns of values. I need to create a button that will take 5 of those columns. It then needs to filter the whole table by values in the one column, there are 4 of 5 values that will need to be shown the rest do not need to be. The columns needed are selected and printed. Its essentially a 1 button way to create a report of the certain things I need

Now I've managed to do the latter half of that. It selects and properly prints what I need. I cannot, however, sort the column. I have no real idea what I'm doing btw. What I've done so far is just use the record macro on the sort function at the top of the column when selecting the custom setting. The problem lies there is there is only 2 things I can filter by. I tried using the recorded macro code to add more but it did not work.

That column will be a list of projects. So lets say A, B, C, D, E, F, and G. I need to only show 4 of those and not show the rest.

Can someone help me out?

Mike

EDIT: I realize I meant FILTER not SORT. Sorry for the mixup.