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 - [login to view URL]
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.
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.
Thanks,
Soneeka.
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.