Macro help for finding unique values within a monthly CSV file

I have been tasked with creating a macro that would pull from a monthly error log the processes that erred that month and post them into an Excel worksheet for that month. I have been able to get it to run once correctly but if I have more data than the last month it does not pick it up.

I can include the code I developed.

Thank you.

There could be numerous reasons why it doesn't work, so yeah, you should post the code and explain where it fails. Does it throw an error? Or it runs but without the expected result?

Maybe you can debug it yourself. I recommend reading at least the "stepping through code" part of this article.
http://www.cpearson.com/excel/DebuggingVBA.aspx

I think I have it working. Now I would like it to close without having to answer the questions on saving changes or information on clipboard. Can I do that? If not I will just document what I want the answers to be.

Not sure about the clipboard, but

Please Login or Register  to view this content.

closes the active workbook without saving. You can use a variable for the workbook or the name of the workbook, like

Please Login or Register  to view this content.