Hi All,
Here is my trouble.

I have 1400 xl files (fortunately) with same # of columns. (4 startin
from 'B')
Col. B to E contains data 200 to 250 rows. Col. A is emply down unti
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 i
written 'average'.
Then copy all 4 columns up unitl where average is written and find las
row in a file name DataAll and paste.

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

--
sazi
-----------------------------------------------------------------------
saziz's Profile: http://www.excelforum.com/member.php...nfo&userid=635
View this thread: http://www.excelforum.com/showthread.php?threadid=49361