Build Me A Macro

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.

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.

Evner: Excel, Maskinoplæring, Software Testning, Test Automering

Se mere: remove duplicates, location testing, excel macro file location, country and state list in excel, a+ roofing, roofing, combine excel, excel macro sort, sort macro, build city, google city state country, city country excel, excel macro add, excel macro download file, excel macro row, excel macro delete text, duplicates excel, excel delete row, excel macro create google search, excel list files add

Om arbejdsgiveren:
( 6 bedømmelser ) Tampa, United States

Projekt ID: #4201763

10 freelancere byder i gennemsnit $121 på dette job


Being competent in different technologies, I can QUICKLY provide you the QUALITY solution, with assurance of Post-Implementation support

$150 USD in 2 dage
(47 bedømmelser)

Please see PM

$300 USD in 3 dage
(8 bedømmelser)

Hi, I can help you. If you need me contact me. See pm.

$100 USD på 1 dag
(7 bedømmelser)

Good evening- I'm a statistical and analytical consultant with years of Excel solutions. I'd be happy to create a macro that does what you need.

$90 USD in 5 dage
(1 bedømmelse)

Hi! I can help you out but need more project details. Check pm for more info

$80 USD in 3 dage
(1 bedømmelse)

check PM for details

$150 USD in 5 dage
(0 bedømmelser)

Hi, I'm a software engineer by profession and have worked for many reputed firms. I have 7 years of professional experience and have done projects on similar line. Let me know if my profile suits your requirement Flere

$150 USD in 5 dage
(0 bedømmelser)

Hi, I am a financial analyst, have good experience in excel. I would like to do this project. Thank you.

$50 USD in 10 dage
(0 bedømmelser)

HI... Looking forward to take up this project. Awaiting your response

$50 USD in 4 dage
(0 bedømmelser)

Hello, I'm expert in Excel macros. I have experience in macros to find, complete and read data. I guarantee that the work would be like your expectations.

$90 USD in 4 dage
(0 bedømmelser)