The obligatory, I'm new to VBA.
I've been using Flow/Power Automate to move an email into a workbook and I'm running formulas to parse it into Different Cells on the same line. (yes I know i can use an email parser but it wasn't working properly and this is just easier.)
Without going into huge details, every time a new email is added to Column A I want it to run all the formulas on the same line.
Such as:
(A2) = Email
(B2) =RIGHT(A$2, LEN(A$2)-SEARCH("Device",A$2)-7)
(C2) =RIGHT(A$2, LEN(A$2)-SEARCH("Net New Device:",A$2)-15)
(A3) = New Email
(B3) =RIGHT(A$3, LEN(A$3)-SEARCH("Device",A$3)-7)
(C3) =RIGHT(A$3, LEN(A$3)-SEARCH("Net New Device:",A$3)-15)
Etc..
I need this in VBA rather than just formulas so I can use Power Automate to move the info from the cells elsewhere.
I've been using Flow/Power Automate to move an email into a workbook and I'm running formulas to parse it into Different Cells on the same line. (yes I know i can use an email parser but it wasn't working properly and this is just easier.)
Without going into huge details, every time a new email is added to Column A I want it to run all the formulas on the same line.
Such as:
(A2) = Email
(B2) =RIGHT(A$2, LEN(A$2)-SEARCH("Device",A$2)-7)
(C2) =RIGHT(A$2, LEN(A$2)-SEARCH("Net New Device:",A$2)-15)
(A3) = New Email
(B3) =RIGHT(A$3, LEN(A$3)-SEARCH("Device",A$3)-7)
(C3) =RIGHT(A$3, LEN(A$3)-SEARCH("Net New Device:",A$3)-15)
Etc..
I need this in VBA rather than just formulas so I can use Power Automate to move the info from the cells elsewhere.