Build Me A Macro

$30-100 USD

Closed

Posted

over 11 years ago

$30-100 USD

Paid on delivery

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.

Excel

Machine Learning (ML)

Software Testing

Test Automation

Project ID: 4201763

About the project

10 proposals

Remote project

Active 11 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

10 freelancers are bidding on average $121 USD for this job

@nayabsiddiqi

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

$150 USD in 2 days

5.0

(47 reviews)

5.3

@gshiels

Please see PM

$300 USD in 3 days

5.0

(8 reviews)

4.6

@cosconeaionut

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

$100 USD in 1 day

5.0

(7 reviews)

3.6

@JScottArnold

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 days

5.0

(1 review)

2.8

@vedranvivoda

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

$80 USD in 3 days

5.0

(1 review)

1.6

@anila87

check PM for details

$150 USD in 5 days

0.0

(0 reviews)

0.0

@soneekajaiswal81

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.

$150 USD in 5 days

0.0

(0 reviews)

0.0

@jeevitha31

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

$50 USD in 10 days

0.0

(0 reviews)

0.0

@khalidkp

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

$50 USD in 4 days

0.0

(0 reviews)

0.0

@jsuarezg

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 days