Peruttu

Need Excel VBA Expert to Automate Keyword Research Data Sorting in Excel

Job Brief (short): Looking for excel VBA expert to help us automate repetitive tasks we do in excel for keyword research. Final deliverable must work on both Windows Office & Mac Excel 2016. We use OneDrive, so if any external data sources are required, must be OneDrive (not Google Drive) compatible.

Requirements

• Excel VBA & Macro expert

• Combine multiple sheets into 1, delete duplicates

• Delete extra columns

• Filter range, then insert row breaks between certain ranges

• Conditional formatting based on if cell contains text string from a list

• Advanced sort (by cell color, then by column x values, then column y values)

• Use n-gram analysis to show frequency count & aggregated data

• Final deliverable must work on both Windows & Mac Excel 2016

What our spreadsheets will include:

4K+ keywords

Search Volume

Group (manually to be grouped by us, but is sped up with n-gram & conditionally formatting)

N-gram details:

Based on keyword data in spreadsheet after 1st macros organize, remove duplicates & finish sorting. Want ability to view n-gram keyword cluster data. In short say keyword phrase is “men shirt” (bigram), want to view combined data (search volume, frequency count, etc) & compare against “shirt” (unigram). This allows us to focus on most relevant & high traffic keywords, not just keyword phrases.

PPC n-gram use case [login to view URL]

Sample n-gram spreadsheet [login to view URL]

Please answer these questions in your bid:

1. Have you successfully created Macros in Microsoft Excel before?

2. Will users be able to interface with your macros (buttons)?

3. How many hours will this take you to complete?

4. How much time do you currently have available to work on this project?

5. Are you confident your final deliverable will work on both Windows & Mac Excel products?

Taidot: tiedonsyöttö, tietojenkäsittely, Excel, Visual Basic, Visual Basic for Apps

Näytä lisää: capturing research data using excel, simple internet research data entry excel file, data entry excel job toronto canada, data analysis excel job, research data entry online job, research data collection excel, data sorting online job, research data entry excel, web research data entry excel, data conversion excel job, research data recording excel, simple data entry excel job, collect data website excel job, research data entry excel sheet, data entry excel job, data entry excel web search, data entry online job search, data entry operator job search, data entry , data mining, excel , web search, email handling, research, data entry, excel

Tietoa työnantajasta:
( 0 arvostelua ) Atlanta, United States

Projektin tunnus: #17727160

16 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Lisää

$555 USD 3 päivässä
(628 arvostelua)
8.3
schoudhary1553

Hello! This is vibrant webtech and I was glad to see that you're looking for help for project Excel VBA Expert to Automate Keyword Research Data Sorting in Excel. I've delivered more than 400 + projects in the las Lisää

$750 USD 10 päivässä
(291 arvostelua)
7.7
zExcel

I'd be happy to help you with this project. I am very familiar with all Excel features and formulas as well as advanced VBA coding. I have also very quick turnover record. So let us discuss this job in more detail Lisää

$300 USD 3 päivässä
(262 arvostelua)
7.7
sonarkaushik

I am very able to create this macro to suffice your requirement. I am ready to start. regards

$388 USD 3 päivässä
(102 arvostelua)
6.2
VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possibl Lisää

$500 USD 4 päivässä
(63 arvostelua)
5.7
fedalal2

Hi, I have experience more 10 years in Excel and VBA , so I'm realy GURU in this. I can help you with this project. Best Regards, Alex

$555 USD 10 päivässä
(33 arvostelua)
5.4
vmadhavan15

am not a random bidder.. 1. Have you successfully created Macros in Microsoft Excel before? Yes check my profile reviews 2. Will users be able to interface with your macros (buttons)? Yes 3. How many hours will th Lisää

$750 USD 10 päivässä
(23 arvostelua)
4.7
aubrey03

I am an Excel VBA specialist. I have created a lot of automation tools using macros. You may check some of my projects here: [login to view URL] I may need up to 5 Lisää

$300 USD 5 päivässä
(36 arvostelua)
5.0
serdaryalcin

Hi, I have developed Excel macros, and almost all my projects here in Freelancer are VBA macro projects. So, 1. Yes 2. Yes. But I need details 3. I don't know, you need to provide more details. Details are n Lisää

$300 USD 10 päivässä
(21 arvostelua)
4.4
sdroberts

Hello I would be happy to help with your very interesting project. I have over 10 years experience with excel and vba at a global financial services company where I automated many processes to improve efficiencies. I Lisää

$388 USD 7 päivässä
(3 arvostelua)
3.3
KolyaEnterprises

Hello, my name is Nick. I've been using Excel since it first came on the market Lotus 1-2-3 before that. I have literal decades of experience in creating, modifying, and updating spreadsheets that deliver results. Addi Lisää

$550 USD 3 päivässä
(1 arvostelu)
2.8
paulodayto08

Hi Good day! I can help you to complete this work in 3-5 days. I already read your post and saw your file and it is very feasible to do in Vba Macro. I am a VBA Macro developer for over 6 years now. I've been exp Lisää

$250 USD 5 päivässä
(4 arvostelua)
2.5
$555 USD 7 päivässä
(1 arvostelu)
1.5
naishodayo

hi,dear. We understand your proposals and I am very interested in this job - 'Need Excel VBA Expert to Automate Keyword Research Data Sorting in Excel'. We are senior software developers and I am able to perform this t Lisää

$555 USD 4 päivässä
(0 arvostelua)
0.0
tsft

Dear Sir/Madam: I do Excel VBA any macro, I consider 4 days, but I can fix time. ASAP. Full services: programming, PM, technical translation/writing. Expertise since 90s. I would like to chat you for further Lisää

$388 USD 10 päivässä
(0 arvostelua)
0.0
mohakbhatia4

I am a VBA expert with 6+ years of expertise in Excel, Work and Outlook VBA macros and integration across applications. I am very much clear about the requirement and I consider myself apt for this requirement. I will Lisää

$505 USD 10 päivässä
(0 arvostelua)
0.0