Have my emails populating into Excel rows and need assistance pulling a substring (8 digit number) out of the string(Column E - which is email body) placing in column F, then equipment into G. I think I need loop maybe?
Have attached a picture of the workbook's data I am working with.
'need use these for column F and G through VBA, i can only get the first email's number i need entire column.
'=MID($E2,FIND("N/A",$E2)+6,8) =MID($E2,FIND("N/A",$E2)+25,3)
I can get the macro to pull the string needed (8 digit number i.e. '88888811' in this case) from the body of the email for the first row but not the rest of the rows.
I thought the above code would place this into the cell but no.
So I am using tndrID = Mid(E, myloc + 6, 8)
This is the code I have modified to find in cell e2 the desired number and place it in column F then the equipment type (dry or reefer) in column G. I believe I've made a mess as it is not placing the MID function into the cell but just the result, so when i fill down the column I am not getting the function to fill down but the extracted string's value.
Have a feeling I need a loop, i am bad with loops......Please assist,
Bookmarks