Tim
Yes.
You say each of the files consists of only one sheet. If the file name is
found in the History folder, do you want the data from the new file appended
below the existing data in that file? If so, what do you want to happen to
the new file (in the New folder) after the data is copied?
What do you want to happen if the file is not found in the History folder?
Move the file to the History folder?
What is the layout of your data? How many columns? Starting in which
column?

As an aside, you say that you have about 125 files to update every month. I
gather then that you have many more than 125 files in all. And you say that
they each file has only one sheet. Is there a reason why you don't
consolidate all the files into one file with 125++ sheets? Just curious.
It is much easier to handle one file with 125++ sheets than handle 125++
files with one sheet each.
Post back with answers to the above questions. Also include the full path
to both the History and the New folders. You can contact me direct via
email if you wish. If you'll be contacting me direct, include a small file
with one sheet of your "History" data and one sheet of your "New" data.
Please don't attach a file to a newsgroup posting. Remove "cobia97" from my
email address. HTH Otto


"Tim Fortune" wrote in message
...
Question from a newbie, sorry if this isn't the right place for it, I am
not even sure if this can be done. Here is the situation
I am stuck in.
1. I have monthly filse that I update, and I do it all manually.
2. The problem is there are about 125 files each month that I update,
and it takes a long time.
3. My files will be in different directories and each file is only
one sheet.
4. I have one directory where all of the files are kept called
History, the new files to be added are in a file called New
5. If the file in New is the same filename as one in Histroy, then I
copy all the data out of New and add it to the
workbook of the same name in History

Is there a way to set up something to automatically take any workbook in
the New folder and if there is a file of the same name in the History folder
then copy all the data from the workbook in the New folder and add it to the
data that already exists in the workbook in the History folder?

If there is a way to do this it would be great because right now this
takes me about 6 to 10 hours to do, and I have to do it twice a month. I
was told by a co-worker that a macro is what I need, but I have no idea
about any of this stuff. Any assistance any of you can provide me on this
would be greatly appreciated.

Thank you in advance for your time and consideration,

Tim Fortune