My goal is to extract all rows that have the latest period in column D (Period).

Column D show period like year.month (201307)

I know I can use filter, but I want to try another way so I can record the macro that I can use every month.

Because if I use filter and choose the latest period, then I will not be able to use the macro next month, that is 201308.

I tried to upload a file to the file upload manager did not find my computer.
Thank you