Jyothi,

A requirement this specific (and unusual) can't be done via any Excel tools.
But a macro could do it, if you're interested.
--
Earl Kiosterud
www.smokeylake.com

wrote in message
oups.com...
I have a 150 XLS files from which I need the data in the 12th row
together in a separate file. Each row should have a first cell with the
original filename.
Is it possible in Excel 2003?


Thanks
Jyothi