| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you select a value and write this in a remote cell | New Users to Excel | |||
| Searching a workbook and copying results to new worksheet | Excel Discussion (Misc queries) | |||
| Select data onto new worksheet | Excel Discussion (Misc queries) | |||
| select lines from multiple worksheets and write to new worksheet | Excel Worksheet Functions | |||
| import select data from another workbook | Excel Worksheet Functions | |||
Threaded Mode
