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
|