Hi Guys, can anyone help me with this.
In the attached workbook i've copy and pasted the body text for a quote request i received via my website customer enquiry form into sheet1.
I'd then like to extract the data from it into the relevant columns in sheet2 on the next available row.
The text that's highlighted in red are the column headers in sheet2 and the text directly below in green is the data i wish to extract in the relevant columns in sheet2
Possibly more complicated is the email address highlighted in green in row1 to the next available row in sheet2 Email column and the Date in column B, sheet1 into Date column in sheet2.
The rows and columns will always be the same but some data fields may be empty with different enquiries.
This is a kinda workaround for my previous problem request
Appreciate any time and effort if someone can help with this
Regards
John
Bookmarks