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!
55 freelancers are bidding on average $113 for this job
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.
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.