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
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 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...
...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.
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.
...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
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 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
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
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...