Đang Thực Hiện

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)

Kỹ năng: Xử lí dữ liệu, Excel, Visual Basic

Xem thêm: 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

Về Bên Thuê:
( 3 nhận xét ) London, United Kingdom

Mã Dự Án: #1024449

Đã trao cho:

manishadk

Pencil Case please view PMB for details.

£50 GBP trong 1 ngày
(10 Đánh Giá)
3.6

43 freelancer đang chào giá trung bình £38 cho công việc này

bharanisrihari

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

£50 GBP trong 2 ngày
(64 Đánh Giá)
6.5
MAnkita

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

£50 GBP trong 2 ngày
(116 Đánh Giá)
6.4
ineedWorkJob

"Pencil Case" - sir plz check pm !

£40 GBP trong 1 ngày
(96 Đánh Giá)
6.1
vserv

Pencil Case - Pls see your messages. Thanks

£20 GBP trong 1 ngày
(64 Đánh Giá)
5.8
koolsidz

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

£25 GBP trong 0 ngày
(56 Đánh Giá)
5.3
agihcam

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

£50 GBP trong 1 ngày
(40 Đánh Giá)
5.2
northwolves

Pencil Case. See PMB please

£30 GBP trong 0 ngày
(48 Đánh Giá)
5.0
ExactSystems

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

£50 GBP trong 2 ngày
(9 Đánh Giá)
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 trong 0 ngày
(30 Đánh Giá)
4.7
dev3dworx

Pencil Case Please check PMB for details.

£75 GBP trong 2 ngày
(19 Đánh Giá)
4.7
KellogITSolution

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

£20 GBP trong 1 ngày
(18 Đánh Giá)
4.5
muhmuuh

Hello! Please check PM for details. Thanks

£30 GBP trong 1 ngày
(22 Đánh Giá)
4.4
oFAZo

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

£45 GBP trong 1 ngày
(16 Đánh Giá)
4.2
microk

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

£45 GBP trong 1 ngày
(22 Đánh Giá)
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 trong 1 ngày
(10 Đánh Giá)
4.0
valleysoftware

Pencil Case. See PMB please.

£40 GBP trong 0 ngày
(10 Đánh Giá)
4.0
sjestuista

Pencil Case .. please check pmb

£30 GBP trong 1 ngày
(6 Đánh Giá)
3.4
Inswinger

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

£30 GBP trong 2 ngày
(4 Đánh Giá)
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 trong 1 ngày
(5 Đánh Giá)
3.2
gssofos

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

£35 GBP trong 0 ngày
(2 Đánh Giá)
3.2