title: Extracting Text from a cell move it in to a cell on another worksheet
body: <p>Hello StackOver Flow folks,</p>
  
  <p>I'm rather new to the VBA language and workflow, but I have some experience coding. My problem that the title does not really help to explain is this:</p>
  
  <p>I receive emails daily that contain information I need to extract out of and move into their corresponding cells. Example of the email is as follows, which I have copied out of Outlook in to an excel worksheet I have named "RawData". I will label columns as <strong>A)</strong></p>
  
  <pre><code>**A)** Send Date
  01/01/2014 Timestamp
  **B)** Subject
  ([Type]) word IndetifierOne IndetifierTwo word 100001
  **C)** Body
  Item HYPERLINK (www.thistheexample.com/100001) Subitem Name HYPERLINK (www.thistheexample.com/name/99321)keyword **All this Information is irrelevant** Item Names
  HYPERLINK (www.thistheexample.com/name/99321)keyword HYPERLINK (www.thistheexample.com/name/99321)keyword HYPERLINK (www.thistheexample.com/name/99321)keyword
  </code></pre>
  
  <p>What needs to be extracted and placed within the columns in order is the </p>
  
  <pre><code>**A)** Date
  **B)** Identifier Two 
  **C)** This has other information input into it later manually 
  **D)** Identifier One **E)** keyword sometimes has more than one line in it separated by a , will vary often 
  **F)** Timestamp 
  **G)** (www.thistheexample.com/100001) this one needs to be a HYPERLINK, the part before the "/" is always the same the IdValue "100001" will change 
  **H)** IdValue from (www.thistheexample.com/100001) which would be 100001 
  </code></pre>
  
  <p>To re-iterate on what I need help with is, I'm unsure of how to get all of this information sorted and placed in to the right cells on an different worksheet, I have been combing StackOverFlow, Mr.Excel for help and guidance but have hit a wall with the information. I'm looking for suggestions or something I can manipulate to do the job please and thank you. Have also tried many different ideas but none of them performed what I needed to a T, to make this task mostly automated.</p>
  
  <p>Thank you for your help and time.</p>