| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I do this ?
Thanks Don - I'll check out FINDNEXT too !
"Don Guillett" wrote: You coud use a FINDNEXT macro to do this. See the vba HELP index. msgbox c.offset(-1) -- Don Guillett Microsoft MVP Excel SalesAid Software "Eric_in_EVV" wrote in message ... I have a spreadsheet that looks like this: C D E F G H I row 29 18-Jan 19-Jan 20-Jan 21-Jan 22-Jan 23-Jan 24- Jan row 30 DISC row 31 ed row 32 25-Jan 26-Jan 27-Jan 28-Jan 29-Jan 30-Jan 31- Jan row 33 DISC row 34 ed What I need to be able to do is search for each occurance of the "DISC" and then use the date (the cell above the "DISC") on a different worksheet in the workbook that contains summary information. I need to be able to report each date that the "DISC" code occurs. I hope this all makes sense ! Thanks in advance for any suggestions ! . |
![Eric_in_EVV[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
