Devam Ediyor

VB for Excel

This is an easy one - so please don't laugh!

I work for a small non-profit housing provider in Baltimore City. As such, we often do mailings to find houses to rehab for our low-income tenants or first-time home buyers.

When I receive a list of raw data it usually contains the following format in column one: LastName, FirstName MI

What I need is a VB-script that will do the following:

1. ignore all entries with LLC, or INC in the name

2. change name format to FirstName MI Last Name

3. insert column to right of column one

4. place FirstName into newly inserted column

This would make my job SO MUCH easier!!

The attached spreadsheet is a perfect example of a small list. You can see that column 1, rows 2 thru 281 have already been completed. This is a tiresome task. To add insult to ingury, I then have to go back and hand type all the FirstName's into column 2!

Beceriler: Visual Basic

Daha fazlasını görün: what can i do for a job, we excel, vb work, vb this, vb job, find the job that is right for you, find home buyers, add inc, vb n, vb in excel, need buyers list, job vb, VB, vb excel, rows, housing, home work for, format excel, find buyers, excel type work, excel small work, excel job, excel add-in, excel add in, do excel

İşveren Hakkında:
( 1 değerlendirme ) Elkridge, United States

Proje NO: #70862

Seçilen:

MichaelAParsons

VIEW PM Thanks!

3 gün içinde 100$ USD
(0 Değerlendirme)
2.0

55 freelancer bu iş için ortalamada 113$ teklif veriyor

xamdam91

looking forward to working with you

1 gün içinde 100$ USD
(54 Değerlendirme)
6.1
wsh2

I am always happy to help a non-profit.. . Hello, my name is Bill. I am a VB, VBA, SQl and Excel programming expert / mentor [screenname:'wsh2'] at [url removed, login to view] and www.experts-exchange.com. I have recently comple Daha fazlası

1 gün içinde 101.95$ USD
(19 Değerlendirme)
5.2
rajanlengde

Ican write the script fr the task. I ahve done many such like this See PMB

in 2 gün içinde100$ USD
(26 Değerlendirme)
5.1
DigitalDreamz

Please check the private message. Thanks, Digital Dreamz

in 3 gün içinde100$ USD
(29 Değerlendirme)
4.5
ExactSystems

Please see detail on PMB. regards, Asghar

in 5 gün içinde150$ USD
(4 Değerlendirme)
4.1
smitech

Dear Sir, Please check PMB. Thanks & Regards.

1 gün içinde 100$ USD
(7 Değerlendirme)
3.8
MustafaSR

Hello, I can provide you with a macro(or vb standalone app, but i think marco is the best choice in your case) for the specified work, with which your work will be reduced to minutes from hours Mustafa S Rampuraw Daha fazlası

1 gün içinde 100$ USD
(10 Değerlendirme)
3.4
concepts2k6

Hello This is fairly easy task to do.. Please see PMB for more details.. Regards

1 gün içinde 100$ USD
(3 Değerlendirme)
3.4
vshree

Please check your PMB. More about our information visit our profile. Waiting for your response. Regards Sandesh M M

in 5 gün içinde100$ USD
(7 Değerlendirme)
3.8
cheungkc

We consider you are not in control of the source file. Our suggestion is in separate mail in PM please

in 2 gün içinde100$ USD
(6 Değerlendirme)
3.1
ingemaj

Excel is my favorite field of expertise. I have already completed several VBA Excel projects at GAF. I'll be glad to help you with your task: it is quite easy for me. Looking forward to work with you.

1 gün içinde 100$ USD
(2 Değerlendirme)
3.0
raheelafzal

Plz see PMB for detail. Thanks, Raheel, Sharpeffect Systems.

in 2 gün içinde100$ USD
(1 Değerlendirme)
3.0
amanullahs

I can do this project as required within two days.

in 2 gün içinde200$ USD
(1 Değerlendirme)
2.7
raviramanathan

Hi I am an experienced VB/Excel/Access programmer with a lot of industry exprience. I can deliver excellent quality work in time at a reasonable price. If all that you require is to split the first column "First Daha fazlası

in 2 gün içinde100$ USD
(2 Değerlendirme)
2.4
ranjaray

This is really a simple task. It is amazing that you are ready to pay more that $100!!! . I will do it for $75. Will take a few hours at most. Regards

in 0 gün içinde100$ USD
(2 Değerlendirme)
1.9
prairiekenya

Am sure you do not want those who say they will try but want those who will do the project and give you a solution you need. we can do that, we are located in Kenya and you can work with us, we have been working with o Daha fazlası

in 5 gün içinde100$ USD
(0 Değerlendirme)
0.0
ssemp00

Hy I'd like to do it

in 2 gün içinde300$ USD
(0 Değerlendirme)
0.0
mrajaysingh

I am a professional VBA script writer.. i know better what should take how much time...even this wont take even a one day. just send me the details and the sample data to my mail.. Thats it.

1 gün içinde 100$ USD
(0 Değerlendirme)
0.0
mxicoders

Hello, Thank you for your time to read our proposal. Mxicoders is a leading IT solutions company to provide e-commerce, e-business and branding solutions to small and medium size business worldwide. Mxicoders Daha fazlası

in 15 gün içinde125$ USD
(0 Değerlendirme)
0.0
softwareashok

Hi This utility I can finish with in 5 to 6 hours of time. I'm already working on this and by the time you are online I can give you the delivery. Please confirm the bidding for me. And also there is another project b Daha fazlası

1 gün içinde 100$ USD
(0 Değerlendirme)
0.0