Rather than rewriting code that works, why not paste your code in and someone
can show you how to modify it.

--
Regards,
Tom Ogilvy


" wrote:

Hey folks,

I have a macro that works great in running a macro on all files in a
folder, but now I need a macro to copy the same column (column I) from
each of the 50 sheets in the folder and paste all of them into a new
worksheet starting at column A and continuing down the line.

Help!