PDA

View Full Version : data extract



eager
08-18-2007, 03:57 AM
:friends: hi all,
i have folder with multi sub-folders. each sub-folder has multi workbooks,
each have multi sheets, one is common between all workbooks in all sub-folders with the name "home". sample of the data in this sheet is:


unit: jamy
name res dep rac for to no 2050 2051 2052 2053 2054
jak1 har wok sap bil ros 12 10 12 13 14 15
jak2 har wok sap bil ros 12 10 12 13 14 15

auto 10 12 13 14 15
manu 3 4 5 6 7

i wan extract the name next to unit in this case "jamy" and the bottom two rows "auto" and "manu" with their number valus from all the sheets in all the folders and output the data in two separate sheets one has the following format

auto 2050 2051 2052 2053 2054

jamy 10 12 13 14 15

and the other sheet will have the same format but will be for manu insteade of auto.

please not thie data in home is not in a fixed location(cells).

TIA
eager