The work is about sorting the data and creating Graphs. Please start your cover letter with " I will finish the work in next 3 Hours" Budget: 20 NZD (Fixed)
I need to build a multivariate normal cdf calculator with Excel (with a Macro). This Excel needs to be able to prompt the user for the number of variates (at least 2) and show the relevant correlation matrix. The inputs are the cdfs of marginal normal distributions and correlation coefficients. The output is the cdf of the multivariate normal distribution
... Item, Color, Size, Qty on Tab 1 (the data on this tab has multiple repeating records) SKU, ,Item, Color, Size on Tab 2 (the data on this tab is a lookup table) I need a macro to run and do the following : 1. Do a vlookup to Tab 2 and populate the SKU alongside Item, Size, Color, Qty on Tab 1 2. Sum up all repeating records in a new spreadsheet by
I am a telecom engineer. I need to get an Excel Macro developed for a large Excel sheet with a block of unique information consisting of 23 rows repeated 2100 times making the total number of rows to be about 48300. I need to add 3 rows of unique information to each block of 23 rows making it a total of 26 rows making the total number of rows 28x2100=54600
Hi. I need someone to build an Excel VB Macro that, when run: 1. takes residential property query field data from Excel provided by the user (e.g. postcode, number of bedrooms etc) 2. runs a search in "[login to view URL]" based on that query and 3. copies the results from that web query back into the Excel sheet. For example, the query contains information
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
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
...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...
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
Hello there. I need help with VBA code in Outlook 2016 so that: When email from "no_reply@[login to view URL]" is received in mailbox, sub "OpenFile" is called. and msg is saved in "k:/files/" as "[login to view URL]". Date should be "year-month-day" and time" hour-min" thank you..
We have an existing macro in excel (created by another freelancer many months ago), that needs some slight modifications done. The macro It was designed to work with multiple .txt source files, but now the source file is just one big single .txt file. The existing script loads values from a .csv finance file and uses that to make calculations in a main
i have two sheets in excel,i want combine rows in one sheet if match with particular column value in excel
I create new project workbooks based on predefined templates from many existing workbooks. What I would like is a new project workbook with drop down menus that lets me choose sheets from different workbooks and copies all selections to the new project workbook.
I have an excel file with 384 input columns and approximately 86000 data point. each row represents 1 second. I want you to write a macro that would take each column copies it and provides an adjacent column with 5, 10, 15, and 20 seconds delays. Simply the column gets copied, inserted next to the original one and the data is shifted down 5, 10, 15
Hi, I would need a quick VBA macro, The task is relatively straightforward: As per attached, there is an excel file with data only in two columns, A and B. For column A you have data for all of the rows, For column B you only have data for some of the rows, The macro should loop through the spreadsheet and copy the content of column A to column
Statement of Work attached - this will be the whole project (with some potential small adjustments)
creating a new options to select by department or cost center or both
Dear Machine Learning experts, I am looking for a python based tensorflow solution which can classify images for the following cases. 1) Color-cast vs Non color-cast images 2) Black & White (or Sepia) vs color images 3) Blurred Photos vs normally sharp photos I have a database of 2000 images for each classes. The main challange here is as follows. Classic CNN architecture (or Inception-V3...
i currently have a file that after 10 days of a completion date the history move to the 2nd sheet. the problem i'm having is that the history overwrites the data and i want all the data on the 2nd sheet to stay and keep.