I am trying to figure out how to write code to look at Colum P of attached worksheet 1 & sort from lowest date to hightest date and then have information from columns A,B,C,H,J,M,N,O on Sheet 1, "Client Files" be listed on sheet 2 in that order from lowest date found in column P. I also need to have the capability of picking what dates from column P I want to select to sort. I tried doing this with a Pivot Table but I could not get the dates to sort in the correct order. The attached has the Pivot Table attached so you can see what I am talking about. Thanks.
Bookmarks