How to make a Macro that will pull data from 2 csv. files

[Chip1234]

Hi I have never really used Macros in excel and am probally in over my head. I will go over what I want to do if someone could please let me know if it is possible... If a newbie can do it.

I have sales info sent to an ftp daily, I then pull the files to my computer and unzip them. They are sent in csv format. From there I normally put them in a file that matches the day e.g. file name 8-11-09 and so on. All those files are saved in a Store file. Now I would like to pull info from two of the csv files into one excell worksheet without opening and copy paste. From there I would like one weeks worth of info on one page.

I will get into more detail if anyone thinks this is something that I should try. I have used excel for a couple years and know most of the common formulas but have never used macro.

Thanks

[mudraker]

Welcome to Exceltip forum

Please take a couple of minutes and read ALL the Forum Rules then edit your thread title by following the instructions in the rules (Rule 1) so that it better discribes your problem/request