Need Excel VBA Expert to Automate Keyword Research Data Sorting in Excel
$250-750 USD
Скасований
Опублікований over 5 years ago
$250-750 USD
Оплачується при отриманні
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?
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 last 5 years and this makes me very confident with your task.I'd like to have more details before proceeding. This way I'll have the chance to elaborate m bid accordingly. I never ask for payments in front. I will only ask you to release the agreed milestones once the task for each one of them is met and you're happy with it. Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon.
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 and I can assure you that you would be completely satisfied with the work,
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 possible time and with the highest quality!
From the Excel, of course, familiar.
Give me a chance to show what I can do!
1. Yes, I have a successful experience in creating Excel macros
2. I can add buttons for macros to ribbon.
3. 3-4 days
4. I can start working immediately
5. None. I'm not sure. Unfortunately, I can not test the macros on Mac.
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 this take you to complete? Depends on the data analysis but max of 2 days
4. How much time do you currently have available to work on this project? Immediately
5. Are you confident your final deliverable will work on both Windows & Mac Excel products? Yes
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 exposed to different excel formulas and functionalities.
Feel free to message me to discuss about this project. Thanks!
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 not enough to give a price. I may need to adjust the price after you provide the details.
4. Depends on the project. But I am quick.
5. Yes. Macros in Apple has limitations, if I face any of these limitations in your project requirements, I will let you know.
Best Regards,
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.
In answer to your questions:
1) yes, as part of my job and freelancing. I recently automated a persons daily stock trading form which will be of help here
2) yes, I can include these in the front page
3) given the size of the task, this may take quite a while. I’m buttering around 20 hours over the course of the week to create, test and debug. But I will endeavour to provide back within a week for review
4) I am available to work large portions during weekends and approximately 2-3 hours each weekday after my day job
5) absolutely. I predominantly work on a Mac but have a windows laptop available to test. The project wouldn’t use other office applications which is where Mac programming usually falls down so I’m positive this wouldn’t be an issue.
Hopefully that’s everything but if you have any further queries please let me know.
Kind regards
Steve
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 deliver an excellent quality project at the cheapest price.
Let me know if you want to discuss in detail.
Regards,
Mohak
