We assume order of files does not matter;
You want to keep "average" as last entry in col A;
"Copy all 4 col......average is written" means the whole file;

1400 files x 200 rows=280,000 rows,
you exceded excel limit of 65,336 rows

"saziz" wrote in
message ...

Hi All,
Here is my trouble.

I have 1400 xl files (fortunately) with same # of columns. (4 starting
from 'B')
Col. B to E contains data 200 to 250 rows. Col. A is emply down until
the end of data in Cl. b to e. at that poin 'average' written in col a.


I want to:

copy the file name into Col A starting for A1 down until where it is
written 'average'.
Then copy all 4 columns up unitl where average is written and find last
row in a file name DataAll and paste.

This code will make my day.
Thank you for making my day.
Syed


--
saziz
------------------------------------------------------------------------
saziz's Profile:
http://www.excelforum.com/member.php...fo&userid=6350
View this thread: http://www.excelforum.com/showthread...hreadid=493614