Macro to read data from csv files based on criteria

Hi, You are in very south India.

I do a similar thing daily with CSV files. I open them and copy and paste all the data I need from them to my Excel worksheets and then close them. I have it where I click a command button, which asks me to find and click on the correct filename. As soon as I do this it opens the csv file and copies and pastes it to my sheet.

You should change your profile on this forum to say you are using 2007 Excel instead of 2003 as it helps us understand your problems better and give better answers.

It is possible. Sounds like an achievable goal.