In Progress

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: visual basic 2010 freelancer, vba freelancer excel, summary freelancer example, new balance freelancer, need freelancer windows, lead bot, freelancer summary example, freelancer small city, freelancer request new project, freelancer make excel, freelancer excel like, freelancer count, freelancer compatible page, freelancer city, freelancer change name, freelancer bot visual basic, freelancer bill, freelancer bank, excel visual basic freelancer, excel windows, less excel, excel less, visual lead

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

Project ID: #1261134

Awarded to:

imudita

I have done it. Please see PM for detail.

$35 USD in 1 day
(30 Reviews)
4.8

4 freelancers are bidding on average $116 for this job

wsh2

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)
5.4
sukhraj

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)
0.0
servingyou

Hello. Please see my PM. thanks

$180 USD in 2 days
(0 Reviews)
0.0