Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fan charts | Charts and Charting in Excel | |||
How do you transfer data from an input form in excel to an excel l | Excel Discussion (Misc queries) | |||
Transfer / combining Excel data | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |