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
Got a VBA macro that's pulling duplicates into excel. There are no duplicates on the original website. Some problem is causing it to repeat some data. Need you to fix this behavior so that the macro only gets the data as is.
... 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
r I am Conducting a study with heart failure patients in Spain. I want to Conduct the study with heart Failure patients in stage 2&3. In this study patients required to participate in a 2 hour focus group discussion held at a central facility in Madrid. Exact place, date and time will be decided by later this week. I am connecting you to seek your help in finding such patients. Do you have an...
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
I am looking for an editor who is experienced in all areas of professionally editing a book. It would be a plus if...for an editor who is experienced in all areas of professionally editing a book. It would be a plus if they can also do interior formatting including content page and do a reference page. Word count is 12095. Please respond with a price.
...I want to use in my project once we decide to move forward but they are very similar. This project will require - Drawling a schematic using Kicad or Eagle based on the reference designs in the IC's datasheet and EVM modules. - Placing the components to the PCB layout and routing the lines on the PCB using CAD - Order low-quantity PCB's and parts
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 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 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
...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
...one that I would like to remember in the form of a painting as a gift to my fiancé Stacey : ) We didn't have a photographer around for the exact moment, but I do have reference photos of the area it took place and I'll supply pictures of us and what we we're wearing. Note: This my first time commissioning a painting, so please excuse my naivety
...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
I am looking to get two reference letters (each letter one A4 paper size) about my work experience to apply for a master degree programe. both letters supposed to be signed by my current employer company GM & my ex-employer GM. I have attached my last two employer experience as a word file.
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
Build a wordpress website similar to a reference site
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
Need an Expert as this is a 192-ball BGA (12 mm × 12 mm, 0.8-mm ball-pitch) Design, complex High Speed Routing Is proficient with Altium Is proficient in PCB layout with Altium, capable of delivering production ready PCB Design files as well as output files , including Component Libraries/footprints/3d Bodies ETC. Expert Only Please, Not here to teach anyone how this is done, just need ...
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
Hi, I have need for a simple 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
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..
I write books about ancient spoken and ancient written languages. I would like Google Classroom classes developed that I can make available to schools, colleges and universities.
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 need you to write some content for a website.
1. use JS framework in developing both frontend and backend website 2. Flow and designs will be provided 3. Designs files will be a Adobe XD format Other info please inquire
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