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
...a game that I play (Pokemon Moon) where you're able to manipulate RNG by noting the position of the clock hands on the portrait before it loads the image. Normally you'd use your eye to guess where it ends (as it's rather quick) and you manually input the result in another application. Using Python, I was able to break down the video into individual
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
I need an easy to fill in and manipulate proposal. I have uploaded a version here, I need one that is much more simplified. It has to say sophisticated and be easy to change the services and information. It is for a web design company. Services include [login to view URL] Logo is attached in PNG
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
Two sets of Data. Sheet1 and Sheet 2 For every 1 line on Sheet2, I need Sheet 1 copied Example: Sheet1: A B C Sheet2: 1 2 3 Sheet3: Fixed RT OT DT Output Sheet: Column 1 Column2 Column3 A 1 Fixed A 1 RT A 1 OT A 1 DT A ...
Hola. tengo ya hecho una pequeña macro que hace un scrapping de una web, donde hay varios productos iguales, pero mi macro no hace logica de cantidad de items en distintas "POS", y por eso descargo 20 "pos" cuando quizas hay 3. y pierde tiempo descargando #NULL#. La idea es que haya un Loop desde i=1 hasta i=X. donde "x" es un nro. dado en dicha w...
...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
Looking for a professional BigCommerce Expert that can do custom code work. For an example, we're looking to manipulate the accordion to show more categories. (Other custom tasks required as well) Please apply if you have previous BigCommerce Custom CODING Experience.
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.
...icon design. In terms of size the design will be dye sublimated onto the back of a white shirt at about 11 x 13”. We will need all work completed in art files that we can manipulate. Please make sure that the logo is somehow incorporated into the design. The fonts used for the brand are Avant Garde Family and Helvetica Neue. [login to view URL]
...for the area mentioned in the title block (weather, temperatures, rainfall, dominant winds, soils) Prepare water management plan with water harvesting solutions. You can manipulate topography; create new zones (i.e., water gardens, ponds, etc.) Prepare irrigation plan Deliverables (both soft and hard copy): Plans: - stormwater management
I REQUIRE AN APP WHERE I CAN MANIPULATE A PICTURE TAKEN BY THE USER AND MODIFY TO THE USERS REQUIREMENTS, SHOULD BE ABLE 1) CHANGE THE OBJECTS COLOR 2)ADD TO THE PICTURE 3) REMOVE FROM THE PICTURE
I have a table of data and i want 2 macros to create 2 reports. The macro will also do relevant formatting and also total all at the bottom of the report List of reports includes: (i) Report one sums by name (ii) report two sums by month.