Build Me A Macro

This project received 10 bids from talented freelancers with an average bid price of $121 USD.

Get free quotes for a project like this
Employer working
Project Budget
Total Bids
Project Description

Login -
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]
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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online