ExcelBanter - TRansfer of data from excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - TRansfer of data from excel (https://www.excelbanter.com/excel-discussion-misc-queries/42593-transfer-data-excel.html)

[email protected]

TRansfer of data from excel

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

Earl Kiosterud

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

All times are GMT +1. The time now is 08:14 AM.