Hi like so many I am new to VBA. My problem is to extract a partial string from a cell under certain conditions. I have done it in Excel, but need a VBA solution if possible. The file is 15000 rows long, and changes daily.
If Column E has he following text. Joblist 0381C - FDS400-203 - H/W SSFDR provided
Only when I have Joblist, and provided then I need to copy the four digits and letter after joblist into a new cell a few columns to the right. Otherwise ignore the cell. There are always four digits, but there may or may not be a letter at the end. I can ignore everything else.