Build Me A Macro

CLOSED
Bids
10
Avg Bid (USD)
$121
Project Budget (USD)
$30 - $100

Project Description:
Login -
USERNAME
PASSWORD
-----
Open "Most Populated US Cities" excel file for NEXT city to use.
Start at the bottom - work your way up OR reverse the list (so least populated cities ON TOP) - delete the row after search, so on restarts it skips empty cells and goes to next.
-----
add keyword from text file (roofing|salons|etc.)
add location (City, State)
country URL always - [url removed, login to view]
ONLY CHECKMARK (Reputation)
-----
After finished sort the list by owner first name (so owner names are on top) and download the first 75 (name "keyword" "city" 1). Delete selected 75 and save next 75 (name "keyword" "city" 2). Repeat Until Done...

Combine the excel files together. Remove DUPLICATES.
-----
Create folder with same city name
-----
Save in folder
-----
Restart again


I just want a macro that can do this. Hopefully not too invasive.

Additional Project Description:
02/01/2013 at 11:24 EST
Photo included of what the program will look like. VERY EASY TO USE!

Logins and password will be included in final text and instructions.


PS - if possible REVERSE my excel file so smallest cities are on top and LARGEST on the bottom like New York.

Skills required:
Excel, Machine Learning, Software Testing, Test Automation
Additional Files: 111.png
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 150
in 2 days
$ 300
in 3 days
$ 100
in 1 days
$ 90
in 5 days
$ 80
in 3 days
$ 90
in 4 days
Hire jeevitha31
$ 50
in 10 days
$ 150
in 5 days
Hire anila87
$ 150
in 5 days
Hire khalidkp
$ 50
in 4 days