Sedang Disiapkan

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!

Kemahiran: Visual Basic

Lihat lebih lanjut: 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

Tentang Majikan:
( 1 ulasan ) Elkridge, United States

ID Projek: #70862

Dianugerahkan kepada:

MichaelAParsons

VIEW PM Thanks!

$100 USD dalam 3 hari
(0 Ulasan)
2.0

55 pekerja bebas membida secara purata $113 untuk pekerjaan ini

xamdam91

looking forward to working with you

$100 USD dalam sehari
(54 Ulasan)
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 Lagi

$101.95 USD dalam sehari
(19 Ulasan)
5.2
rajanlengde

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

$100 USD dalam 2 hari
(26 Ulasan)
5.1
DigitalDreamz

Please check the private message. Thanks, Digital Dreamz

$100 USD dalam 3 hari
(29 Ulasan)
4.5
ExactSystems

Please see detail on PMB. regards, Asghar

$150 USD dalam 5 hari
(4 Ulasan)
4.1
smitech

Dear Sir, Please check PMB. Thanks & Regards.

$100 USD dalam sehari
(7 Ulasan)
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 Lagi

$100 USD dalam sehari
(10 Ulasan)
3.4
concepts2k6

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

$100 USD dalam sehari
(3 Ulasan)
3.4
vshree

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

$100 USD dalam 5 hari
(7 Ulasan)
3.8
cheungkc

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

$100 USD dalam 2 hari
(6 Ulasan)
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.

$100 USD dalam sehari
(2 Ulasan)
3.0
raheelafzal

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

$100 USD dalam 2 hari
(1 Ulasan)
3.0
amanullahs

I can do this project as required within two days.

$200 USD dalam 2 hari
(1 Ulasan)
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 Lagi

$100 USD dalam 2 hari
(2 Ulasan)
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

$100 USD dalam 0 hari
(2 Ulasan)
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 Lagi

$100 USD dalam 5 hari
(0 Ulasan)
0.0
ssemp00

Hy I'd like to do it

$300 USD dalam 2 hari
(0 Ulasan)
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.

$100 USD dalam sehari
(0 Ulasan)
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 Lagi

$125 USD dalam 15 hari
(0 Ulasan)
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 Lagi

$100 USD dalam sehari
(0 Ulasan)
0.0