select data and write results to new worksheet in same workbook
 

All the column (DC) titles are different. I want to search each column and
return the results to a blank sheet in the workbook - return the column name
and the most recent date where the result in the S/F field (there are 2) is
"S".
The first S/F field tells if something was successful on the first try; if
it was not (status is F) and there may be a retry and that status is in the
second S/F field.
For example, on the attached sheet, LAN last date should be 031609, AUB is
032109, CST is 030909, and WCH is 032109

Results will just need the DC (LAN, AUB, CST, WCH) and the most recent date

Thanks for your help

select data and write results to new worksheet in same workbook
 

sorry, here's what the spreadsheet lookc like
DC LAN AUB CST WCH
Date 030209 030209 030209 030209
S/F S S S F
notes
S/F
Date 030409 030409 030409 030409
S/F F S F F
notes
S/F S S S
Date 030509 030509 030509 030509
S/F F F F
notes
S/F
Date 030909 030909 030909 030909
S/F S S S S
notes
S/F
Date 031009 031009 031009 031009
S/F S S F S
notes
S/F
Date 031609 031609 031609 031609
S/F S F F F
notes
S/F
Date 32109 32109 32109 32109
S/F F S F S
notes
S/F


"CCJ" wrote:

All the column (DC) titles are different. I want to search each column and
return the results to a blank sheet in the workbook - return the column name
and the most recent date where the result in the S/F field (there are 2) is
"S".
The first S/F field tells if something was successful on the first try; if
it was not (status is F) and there may be a retry and that status is in the
second S/F field.
For example, on the attached sheet, LAN last date should be 031609, AUB is
032109, CST is 030909, and WCH is 032109

Results will just need the DC (LAN, AUB, CST, WCH) and the most recent date

Thanks for your help

select data and write results to new worksheet in same workbook
 

Excel 2007 PivotTable
with Advanced Filter
http://www.mediafire.com/file/lmwyyj...03_26_09a.xlsx