Getting information from one excel file into another?

[coach]

I am trying to help my father with his small business. He has an csv file
he gets from his supplier...

His process now is he opens the file in excel, and then manually copies his
information into his own excel spreadsheet for his uses.

I am sure there is a way he can take his spreadsheet and create a macro?? or
something that will automatically import the information he needs out of the
csv file into his spreadsheet. His current process takes him about 8 hours
a week and I told him this should be able to be done virtually automatic.

Any ideas?

 

[Jacob Skaria]

If you are familar with macros; the below link would be helpful

http://www.programmersheaven.com/mb/vba/368555/368555/read-and-write-to-csv-file/?S=B20000