Get 1 line from multiple records

[JKT23]

Hello...I have hundreds of excel records, all from 1 template I made, so columns are all the same, and I would like to grab 1 specific row from each record and put onto new sheet, for the pupose of being able to sort, etc. The records are baseball stats procduced from a game I play, so any similarity to MLB ends at the name of the players, stats are not actual...So, here is what I have in a shortened version:

Columns: Name Year Team Ave AB's Runs Hits Etc
Totals XX XX XX XX XX XX XX XX
XX XX XX XX XX XX XX
XX XX XX XX XX XX XX

Ok, now imagine I have hundreds of these sheets, the Totals row, Line 2, on the sheets, is the row I want to grab from each player. (I have the sheets so that the numbers add upward to the totals). Basically when finished I want to get rid of the Year and Team column as these are not needed. So the finished project should read as follows:

Columns Name Ave AB's Runs Hits Etc
Totals AA XX XX XX XX XX
BB XX XX XX XX XX
CC XX XX XX XX XX

Ok, how do I go about accomplishing this, or do I just have false hopes? I am not a programmer, but was thinking writinig a macro would help, but not sure. Any pointers or solutions would be greatly appreciated.

Thanks

[martindwilson]

is that sheets in same workbook or different work books ?
if in same workbook

Please Login or Register  to view this content.

adapted from one of tom ogilvys at all experts .com
http://en.allexperts.com/q/Excel-105...e-sheets-1.htm

[JKT23]

Same file folder, different workbooks

[martindwilson]

blast! and bother
ok here's another one
copy all workbooks in to a new folder create a new one and save it in the same folder (this will preserve originals if something goes badly wrong.unlikely but you never know )
stick this code into a new module in the new workbook
i tried it on 4 workbooks with 4 sheets in each and it seems ok

Please Login or Register  to view this content.

this is a modified one originally by Bob Umlas at allexperts .com

[rylo]

Hi

Put the attached file in the same folder as the summary files, and run the macro. See how it goes.


rylo