Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Orders come in by Outlook Express email. I copy the email to an Excel
worksheet and then I process the order. Orders may be multiple items. Each item in the order begins with the words "Item Ordered" in column A which is then followed by three rows regarding the item ordered and then a blank row. How do I write the following in Excel VBA: Find First "Item Ordered" in column A << Code to process the item ordered Find Next "Item Ordered" in column A If "Item Ordered" found Then << Code to process the item ordered Else Message "All items in order have been processed" End If Thanks for all help! Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find a First Occurence in a Column | Excel Discussion (Misc queries) | |||
Find Last Occurence | New Users to Excel | |||
find 2nd occurence | Excel Discussion (Misc queries) | |||
Find Last Occurence in a Range with VBA | Excel Discussion (Misc queries) | |||
Find first occurence of specific data in a column. | Excel Programming |