Excel Macro -

I will provide a small sample of data attached to this request on the first page of the spreadsheet.

I will provide 1 example of what I want the data to look like on the second page of the spreadsheet (please look at this closely)

This must be compatible with Excel 2010.

The macro requirements are as follows:

1) Add in 3 columns to the front (A,B,C).

2) In the A Column from where the Bank Name is in row D (after you have added the 3 columns) to Average Investable Balance I will need the Bank Name listed on every row.

3) In the B column under the same restriction I will need the City.

4) In the C column I will need the Zip.

5) This must loop through a whole sheet until there is no more data - there may be hundreds of thousands of lines - you have been given only a SMALL sample of data.

6) There are 8 blank lines between each listing and that will never change, so the macro must count down 8 blank lines and then start again with the new name, city and state.

I will be looking for more Macro/VBA work to be done in a fast manner - so if you can provide this quickly, it may lead to more work in the future.

I need solid English speakers for this and it to be done within 2 days - this is not highly complicated, but currently no one at work as time and Freelancer has been reliable in the past.

If there are any questions, please send them to me. I will be picking a winner in less than 3 days if it appears that someone fits the bill.

***** ADDITIONALLY: When you apply, send me a message with a summary of how you would complete this project - I need this to make sure you understand the project and are not a bot - if you do not add this in you will not be considered for the project or future work. *****

Skills: Excel, Visual Basic, Windows Desktop

See more: windows 8 freelancer, where to start as a freelancer, visual basic 6 freelancer, visual basic 2010 freelancer, vba freelancer excel, summary in freelancer, summary freelancer example, new balance freelancer, need a freelancer for windows 10, lead bot, i need excel freelancer, how to bill as a freelancer, how to apply to be freelancer, how to apply as a freelancer, how can i start as a freelancer, how can i apply for freelancer, how apply freelancer, freelancer with excel, freelancer where to apply, freelancer to windows 10, freelancer summary example, freelancer small city, freelancer request new project, freelancer make excel, freelancer in windows 10

About the Employer:
( 26 reviews ) Aurora, United States

Project ID: #1261134

Awarded to:


I have done it. Please see PM for detail.

$35 USD in 1 day
(30 Reviews)

4 freelancers are bidding on average $116 for this job


Greetings Bryn Mawr college from another Philly ex-patriot (now in Easton PA).. {smile}. 25+ year MsExcel expert. Have reviewed your requirement and example workbook. Question: Regarding the City transposition, More

$99 USD in 1 day
(25 Reviews)

Hi, In the evening I will give you demo for this project. About me: My name is Sukhraj Singh. From last 5 years I am working as a software engineer. I am MCA from my qualification. Please give me this project More

$150 USD in 7 days
(0 Reviews)

Hello. Please see my PM. thanks

$180 USD in 2 days
(0 Reviews)