I gang

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!

Færdigheder: Visual Basic

Se mere: 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

Om arbejdsgiveren:
( 1 bedømmelse ) Elkridge, United States

Projekt-ID: #70862

Tildelt til:

MichaelAParsons

VIEW PM Thanks!

$100 USD in 3 dage
(0 bedømmelser)
2.0

55 freelancere byder i gennemsnit $113 for dette job

xamdam91

looking forward to working with you

$100 USD på 1 dag
(54 bedømmelser)
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 Mere

$101.95 USD på 1 dag
(19 bedømmelser)
5.2
rajanlengde

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

$100 USD in 2 dage
(26 bedømmelser)
5.1
DigitalDreamz

Please check the private message. Thanks, Digital Dreamz

$100 USD in 3 dage
(29 bedømmelser)
4.5
ExactSystems

Please see detail on PMB. regards, Asghar

$150 USD in 5 dage
(4 bedømmelser)
4.1
smitech

Dear Sir, Please check PMB. Thanks & Regards.

$100 USD på 1 dag
(7 bedømmelser)
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 Mere

$100 USD på 1 dag
(10 bedømmelser)
3.4
concepts2k6

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

$100 USD på 1 dag
(3 bedømmelser)
3.4
vshree

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

$100 USD in 5 dage
(7 bedømmelser)
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 in 2 dage
(6 bedømmelser)
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 på 1 dag
(2 bedømmelser)
3.0
raheelafzal

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

$100 USD in 2 dage
(1 bedømmelse)
3.0
amanullahs

I can do this project as required within two days.

$200 USD in 2 dage
(1 bedømmelse)
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 Mere

$100 USD in 2 dage
(2 bedømmelser)
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 in 0 dage
(2 bedømmelser)
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 Mere

$100 USD in 5 dage
(0 bedømmelser)
0.0
ssemp00

Hy I'd like to do it

$300 USD in 2 dage
(0 bedømmelser)
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 på 1 dag
(0 bedømmelser)
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 Mere

$125 USD in 15 dage
(0 bedømmelser)
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 Mere

$100 USD på 1 dag
(0 bedømmelser)
0.0