En cours

Excel VBA String Search and Split Cell Macro Needed

Hi,

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)

Compétences : Traitement de Données, Excel, Visual Basic

Voir plus : vba macro split string, excel search split cells, excel vba split string, vba excel split string cells, excel macro split string cells, excel macro split cell, split cells vba, split string cell vba, split cells vba excel, excel macro split, split vba search, vba excel macro split string cells, excel vba split cells, vba search string, split string project 2007, split macro excel vba, excel split cell string, vba split string cell, split string words excel vba, excel vba split cell, search string excel split cell macro, excel vba string cell split, excel vba split cell macro, what is search string, what is a search string

Concernant l'employeur :
( 3 commentaires ) London, United Kingdom

N° du projet : #1024449

Décerné à :

manishadk

Pencil Case please view PMB for details.

50 £ GBP en 1 jour
(10 Commentaires)
3.6

43 freelance font une offre moyenne de £38 pour ce travail

bharanisrihari

"Pencil Case" - Hello, Excel Macro expert here. Please check PM for details. Thanks!

50 £ GBP en 2 jours
(64 Commentaires)
6.5
MAnkita

Hello,Please refer your [url removed, login to view] you.

50 £ GBP en 2 jours
(116 Commentaires)
6.4
ineedWorkJob

"Pencil Case" - sir plz check pm !

40 £ GBP en 1 jour
(96 Commentaires)
6.1
vserv

Pencil Case - Pls see your messages. Thanks

20 £ GBP en 1 jour
(64 Commentaires)
5.8
koolsidz

"Pencil Case" - Please see PMB (You will be surprised) :)

25 £ GBP en 0 jours
(56 Commentaires)
5.3
agihcam

"Pencil Case", please check your PMB for more details.

50 £ GBP en 1 jour
(40 Commentaires)
5.2
northwolves

Pencil Case. See PMB please

30 £ GBP en 0 jours
(48 Commentaires)
5.0
ExactSystems

"Pencil Case" Please see a better solution on PMB. regards

50 £ GBP en 2 jours
(9 Commentaires)
5.0
DrTech76

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?

20 £ GBP en 0 jours
(30 Commentaires)
4.7
dev3dworx

Pencil Case Please check PMB for details.

75 £ GBP en 2 jours
(19 Commentaires)
4.7
KellogITSolution

Hello Ready to start right now. Please see your PMB for details. Thanks

20 £ GBP en 1 jour
(18 Commentaires)
4.5
muhmuuh

Hello! Please check PM for details. Thanks

30 £ GBP en 1 jour
(22 Commentaires)
4.4
oFAZo

'Pencil Case'. Exceptional quality & Quick work. Please refer to Profile & PMB for details. Thanks FAZ

45 £ GBP en 1 jour
(16 Commentaires)
4.2
microk

"pencil case" **********Please SEE PM ***********

45 £ GBP en 1 jour
(22 Commentaires)
4.2
piyushdpatel

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

50 £ GBP en 1 jour
(10 Commentaires)
4.0
valleysoftware

Pencil Case. See PMB please.

40 £ GBP en 0 jours
(10 Commentaires)
4.0
sjestuista

Pencil Case .. please check pmb

30 £ GBP en 1 jour
(6 Commentaires)
3.4
Inswinger

Pencil Case. Please see the private message. Hoping to get the work from you. Thanks.

30 £ GBP en 2 jours
(4 Commentaires)
3.3
cdumitru

Hello, I am interested to do this task. Please see PMB for a draft. Best regards quote : "Plastic Pencil Case 500mm-125mm"

40 £ GBP en 1 jour
(5 Commentaires)
3.2
gssofos

"Pencil Case". I have worked a lot on excel Macros. Please check PM for sample.

35 £ GBP en 0 jours
(2 Commentaires)
3.2