Opening Multiple files and Copying the info all to one other sheet

[MsLucy]

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???

[exceluserforeman]

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

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???
>
>

[MsLucy]

Mark...
thanks for trying to help me with this....
There is one common partname for these files. I have one folder titled
"trbtix06" where I keep two sheets (TrbTk1G & Trbtk1D). The files i
need are saved as "TrbTk1G..." then they will have something like
".01066.xls in which "01" is the month, "06" is the date, and "6" is
the date of the week. all the files are in one folder. I do need to do
a select all, there are not headers on the sheet.There is only one
sheet in each workbook....I will email you an example of our the sheets
I use.