I am hoping someone could help me out with a VBA Excel macro.
I have received a worksheet in Excel 2007 which contains product names in one column, and I need to sort this into a logical format so I can use it. However, the list itself is not in any kind of logical order, is approximately 10 000 rows long and I am going to have to do this every month!!
Basically, what I would like to do is search for certain keywords which are common to most of the entries and move them into separate cells in different columns (but in the same row as the original entry).
I have attached an example of some strings I have and what output I would like.
I am ideally looking for an excel macro solution but am open to other suggestions as well.
This is a potential 2-part project; this being part 1.
My budget for this project is £50.
Please respond with the words in Cell C10 of the attachment in your reply to me otherwise I will ignore your bid
(this just proves you have read my brief)
43 freelance font une offre moyenne de £38 pour ce travail
Hello! In my opinion the requested "Pencil Case" (the proof-of-read) should have "Measurement1" 500mm and "Measurement2" 125mm instead of having "Measurement1" 500mm-125mm, isn't that right?
'Pencil Case'. Exceptional quality & Quick work. Please refer to Profile & PMB for details. Thanks FAZ
Pencil Case Hi This is Piyush Patel I have 6 yrs of Exp in VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VB.NET. Please Check My PM
Hello, I am interested to do this task. Please see PMB for a draft. Best regards quote : "Plastic Pencil Case 500mm-125mm"