select data and write results to new worksheet in same workbook

  • Thread starter Thread starter CCJ
  • Start date Start date
C

CCJ

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to copy a range of cells and paste into a new workbook in differentcolumns 3
Excel Workbook, Data Selection by Date 8
Compare data from two different worksheets with a condition 2
Selecting the latest record for transactions 3
EXcel 2000 IF-AND Statement 3
How do I move entire row from one excel sheet to another 3
How do I transfer data from one worksheet to another? (Excel 2003) 0
count based on 2 criteria (date and status) 4

Back
Top