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. *****