Hello,
I may be able to help.
You must send this information and much more to


Location of files.
Is there a common partname for all files? eg: date2005.xls
Are all this files in one folder or different folders.
Is select All info or are there headers in the sheet?
is there only one sheet in each workbook?

Please send the target book and one source book to me so I can determine the
layout.

See my stuff at
http://www.geocities.com/excelmarksway


- -Mark



"MsLucy" wrote:

I'm trying to open Up a months worth of files usin a macro... and then
having the macro automaticly selecting all the information and pasting
it all to a new sheet.
I want the information paste just below the last information pasted.
I need to create a userform that just asks for the moth for which the
files are to be extracted and then open, copy and paste.
Can anyone help me???