Glad you got it squared away.

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"workaholic" wrote in message
...
All Done, many thanks to you both.



"workaholic" wrote in message
...
Hi I am in need of help:-

What I have:-
Over 400 spreadsheets and increasing, all of which have 24 columns and
the
first row being a header row naming these columns, they all have
different
amount of rows.

What I'd like to have:-
Another sheet with five columns. 1st column listing the 400 odd
spreadsheets
by filename, in the next column I'd like to list the max value from a
given
column from the spreadsheet listed in column A, the next 3 columns would
do
the same, listing the max value from a column in the sheet listed in
column
A.
As you can see this would involve 1600 or more cells (not including
column
A) that I'd rather not fill manually. I'd be happy to fill the first
column
listing the 400 other files.

Any ideas welcome.