1) Windows 10 pro, Excel 2016 2) User should be able to identify target folder for process to run on all excel sheets in the folder as a batch. 3) Source data is Excel sheet (no more than 4 columns, and max. 100 rows) 4) Output is csv (12 columns, and no more than 100 rows) 5) Some columns in source will be split into many columns in output
Create a Macro in EXCEL: 1. Count the number of spelling mistakes in a cell eg: "The lanb is a world beest" Count = 2 2. List the all the spelling mistakes in a cell eg: "The lanb is a world beest" Mistakes= lanb,beest 3. Exclude the spelling mistakes based on the word count. eg: if we say letter count as 4 then if word "cat " is misspelled then it
Looking for someone savvy with VBA (Excel) - essentially good with macros, and linking this to Word. In need of a workbook that can serve as: 1. an upload tool (for a list of questions) 2. a db sheet Q&A format, for the search tool to search for matching answers to the input questions 3. a functionality that will take the matching questions
Amazon has millions of "Exclusively for Prime members" items. I need database of all Exclusively for Prime members items. pls check below without log in to your amazon account [login to view URL] OR [login to view URL] I would like you to provide product link, price, BSR and total reviews of each Exclusively for Prime member item Thank you
The original excel file has one sheet and output should have 3 additional sheets than the original: 1) extra sheet1 (just a selection of columns from original) - date filter 2) extra sheet2 (some pivots should be created in this sheet) 3) extra sheet3 (a new selection of column from original) - date filter 4) vba code should have comments and be explained
I need a macro or bot created that will do the following function. 1. Login to Google voice account 2. Sent text message 3. Record any response to text message to file The macro/bot should support doing this for a list of multiple accounts pulled from a .csv file with the following fields. Google Voice Account Login, Google Voice Account Password
Keeps average $/hr as well, charts your progress, includes a printable results sheet to carry to casinos with you. *Runs on Microsoft Excel Results Tab: Keeps track of Casino name, the time you started and stopped playing, amount won or lost, and any information worth keeping track of. Daily Progress Chart: Be able to see your career in motion,
...looking for a cron script to extract data from a website to a database. Search URL: [login to view URL] Search Query: Huddersfield Search Results: around 1269 pages It needs cycle through each search result, and store the following details in a MySQL db; Application Number
I need SEO specialist to increase my website rankings, help me setting up google analytics ( google console)
I need someone to add Schema markup on my website to get organic star rating to show in search results. I only want to hire someone who has experience in this and can show me examples of completed work like this. It should be a simple code and this is for 5 websites. Please send examples of work you have done
Get me high up Google search results $90 I m a scientist & designer Fortunately by luck I have an unusual name. I need to fairly quickly start to get higher up Google search results. By whatever way is best to do it most quickly.. I would like to see some strange results from other web sites PUSHED DOWN. My entries pushed UP the list. I can giv...
I am looking for a small database with easy interface ( like a small app ) or excel with Macros file where i can put all my soccerplayers in. I am a Soccer Coach and i want to have a Database where i can put all playing times, assists, goals scored, exchanges and some other information in live time during the match... so it has to be a easy interface
I [login to view URL] for a lawyer to obtain results in taking off a few false postings appearing on search results.
I have a finished vba-code to web scrape soccer results from a website. The structure for the scraping is set, and the code has worked for months, but the problem is that the website has updated its security. So I need to get past the error "permission denied", and make the code more robust, since it also fails by losing it structure when I get past
I have a vba-code to web scrape soccer results from a website. The structure for the scraping is set, and the code has worked for months, but the problem is that the website has updated its security. So I need to get past the error "permission denied", and make the code more robust, since it also fails by losing it structure when I get past 200+ links
...need to create an excel macro file, it is very easy and fast work. all the details are attached in the files attached include a sample excel file. i need this done very fast, preferably within next 1-2 hours if possible i am copying the list of details about macro function again, it is attached in the text file also:- the excel file details are as
...i need to create an excel macro file, it is very easy and fast work. all the details are attached in the files attached include a sample excel file. i need this done very fast, preferably within next 1-2 hours if possible i am copying the list of details about macro function again, it is attached in the text file also:- the excel file details are as
I have different excel files reading from each other.. each file has statements on it... i want these statements to have have a unique identified, if the problems are the same i want them to have the same unqie identified.
...use a google research site:[login to view URL] I need to get all the URL of all the results pages. The issue is, as you know, Google limits me by the amount of result I can see. It seems there is about 5K pages to scrap. If you can do this easily, you'll maybe have other jobs to scrap data Inside those pages. Please start your offer with the word "Results...
I need someone to create a sitemap which stores search results without a database attached, the website uses the iTunes API and search functionality is fairly straight forward. I simply need to add all of my searches to a dynamic SEO compatible sitemap.
For a statistical project I need some data (maybe taken from pages down here) with specific fields in plain clean CSV format. At least the data should contain the seasons from 1995/1996 until actual season for Germany/England/Italy/Spain/France/Scotland/Netherlands (1st league and 2nd league) Country League name Season Date of match or number of match day in season Home team name Away team name ...
Hello there! We are looking for freelancer to build us a PHP Script like this: - Search for a predefined search term on Google (results: 4'100 results). - For every entry: + Go to the site of the result + Crawl 4 information + Create an xls with an entry for every result, including the crawled information (structure of the data will be presented
The following page, creates a profit & loss from this kind of page It takes the top 2 fastest times in the column Avg Rank Its displayed here: [login to view URL] The problem is that I want to have profit & loss for another column on that page, called Rating. Which will also take into account the top 2 highest ranked entries. I need that to be displayed on the same page Finally the tot...
...within next few minutes if possible i need all data in different columns of sheetA copied 43 times in sheetB, when i run the macro For example: sheet A: columnA columnB tex1 text1.1 text2 text2.1 then when i run macro, in sheetB i should get columnA columnB text1 text1.1 ... ... copied 43 times text2 text2.1 .. ... copied
...step 1: [login to view URL] 2) On the same site, search for "pool insurance". Notice the big blue area. I would like to not show this upon search and just show the message on this file, [login to view URL] when no search results are found. Here is the file for step 2: [login to view URL]
Hello Freelancers, I want a macro or visual basic code to extract the data from PDF to Excel Automatically. I have PDF and sample. Dont get forget to mention you offer I think it is not more than an hour work. Happy bidding
I manage a PHP website and MySQL results database for a small track & field athletics club. I'm looking to save time on data entry by importing results directly from a 3rd party results website using a web scraper. The 3rd party results website don't have an API, hence the requirement for a web scraper. I'd like the the web scraper to work like an
looking for someone to assist with my SEO optimization. - Keyword & Market Research - Onsite SEO in form of White hat SEO - meta tags - web promotion - anything that will get traffic to my website and make me be the first listed when searching.
I need the script of macro to sort my spread sheet. I need something that I can use myself on a daily basis. The attached file should be sorted based on the name of the city - which is part of the string in the first column. Each city should be sorted out to a separate sheet (if possible). Please type the word "Root Beer" at the end of your proposal
...user. Once the profile has loaded, click back it'll bring you back to the 1st page search results. The issue is when you go on page 2 or 3, click any user and go back it still brings you back to page 1 search results. I would like it to bring you back to the search result you were on. Here is the file you'll be editing, you can review it here: https...
I wish to be able to send students results from the database using SMS
Excel macros play an important role to perform repetitive operations in excel. It takes lot of time, when handled manually. I have done quite good amount of work in excel macro handling. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, Image handling, Shapes variation, Pivot Tables, Text to columns
I need you to create a macro for vehicle that are changed. For example, if a customer wants to replace a white bumper with black then a parts list is generated. From that list of parts a quote is created. Basically, it's a option pricing. If you think there is better way to do it on access or any other way then please let me know. I would like to
Can you get our website [login to view URL] ranked in the top 3 search results for the next keywords for the following urls: [login to view URL] Abraham pop huren Opblaasbare abraham pop huren [login to view URL] Sarah pop huren Opblaasbare
I have an IT company that offers IT Support, Managed services, IT Projects, wireless, etc. I have a few campaigns that have not been successful, i am looking for better results. Only if you know what you are doing and confident of your work contact me. Also if you have other Internet Marketing ideas, I am open. I am looking for a long term relationship
I have an Microsoft Word document and i want to add a dropdown list to one place on the document. It will contain 3 peoples names - Steven, Darren and Michael....If darren is selected (location A) on attached, then darrens email address needs to be placed in the footer (location B) and his photo shown on the document at location C. If michaels name is selected, his email address and photo needs to...
Excel expert needed for a small job Iv added a new column to my excel file and my macro has producted an error [login to view URL] Before macro use to produce a sheet with last weeks bookings now i want to create a sheet with some of the columns hidden. Should be an easy job and my budget is 20 or max €30
...click script(click every 3 minutes) or keyboard script (Ctrl+Tab every 3 minutes) to keep a desktop active. The catch is that this will run in an office environment that has a macro blocker in place. Simply put, macros or hotkeys don't work (AHK/Jitbit/etc). The only way for it to register input is from physical keyboard keystrokes or mouse movement. I