I have data in excel with two columns date and value. I need to do a what if analysis. That needs to accept some variables. I will enter a date, initial quantity, a percentage difference when that action needs to be repeated, a factor that multiplies the initial quantity. I need to know what is the average price on each of the entry dates and what
An excel file with 11 tabs. The coder will create code so the user can add and delete rows with specific characteristics The coder will create code so the values entered in certain fields are summed to other worksheets
I want a twilio interface that uses classic vba from access and excel 1. a table, xl sheet with a list of phone number 2. i click on a p;hone number, the prompt is phone ot text (i can do all the vba interfaces, i need the twilio rest api done) 3. if it is a call, the call flow .. calls me, when i answer, connect the call to the client 4. when i
Hi, I need someone to help with the creation of 5 spreadsheets. I attach one template for reference. I need this for: English Premier League English Championship Italian Serie A Spanish La Liga German Bundesliga I need to pull in fixtures from the below link to my spreadsheet. This file will need to be filtered depending on the Spreadsheet template being used. [login to view URL] For example,...
Alert Let me tell you 1st, if you applied Bid for this project and then you say i cannot do this job i will report about your unresponsive behavior to freelancer support department. ________________________________________________________________________________________ Work Already Done I already have code of CogNos. here it is the link of code and
I have an access based contacts database that comprises UI as well. I need a VBA / MS Access expert to analyze/optimize the VBA codes in the DB. Also, there is a functionality that has to be updated, which can trigger the change in DB structure and source code accordingly. This functionality shows if a postcard was sent to the selected manager’s contacts
...6-a2be20ce2fd9/convert-contents-of-a-formatted-excel-cell-to-html-format?forum=isvvba It works perfectly, but is very slow as it steps through each cell one at a time. e.g. to covert a single 1000 character cell, it takes about 10 seconds on my fast computer. I found a fix I think, but I need a VBA expert to do it for me (or find a fix that will):
A small job. Need someone to make a excel-macro (or any other way it can be done) to do a series of calculations on a sheet of excel workbook. It's a small job. Details will be discussed.
Hi, if you know Excel, Word and VBA, this one is easy! Here is the program flow: 1) User enters First Name, Last Name, Address, City, Province, Postalcode into Excel (columns) 2) Clicks a button "Create Letters" and for each row that has a column "Already Printed?" marked "No" it takes a Word Template and merges the fields in for the letter (add...
Want to scrap the gaming site - ONLY Macro expert bid -Want to scrap from VBA only . Please bid. Details will be shared with winning bidder.
Hi, I am creating an excel userform based tool and would like to hire someone who is proficient in excel, userforms and VBA. This project is expected to last for around 2 months full time(significantly less for a person who has great VBA skills).l I know exactly what is required to be built and have a Proof-of-concept with the code already ready and
Phase 1: Data Staging from Stock Exchange file or API with applied calculations using Combinatorics. Output in webapp or excel
I need very simple code....unmatched it needs to Append those unique "Quote Numbers" into the tblProposalStatus. (There should not be Duplicate "Quote Numbers" in the tblProposalStatus Table.) I need VBA Code. So I can take what you submit and paste it into an event action (button: on Click) Private Sub CmdRunButton1_Click() Your Code Here End Sub
I am in need of a qualified UK accountant to prepare my 1st year's company accounts (micro entity) by October 7th 2018., with a view to then winding up the company. I never kept receipts but I can provide bank statements
set a timer in an excel worksheet, once condition met in the worksheet1, copy and paste certain data to MS outlook and send it out everyday , back to workbook, create a worksheet2 and name it (mmddyy the date we create) save the data(we send to outlook) in the same workbook in the attached excel, if G3 >10%, copy A3:E3 to outlook again if G4>10%
Extract data from a website with pagination. Need to get the data to Excel file. Not a complex data extract, but since it has pagination I am not able to get it using available tools. Developer with Excel VBA knowledge & web extracts should be able to do it easily.
Make me a Macro / VBA / Program To be able to Nest objects in corel draw into a given size area, and be able to dictate what gap to have between the objects, and also dictate the gap between the given area and the objects So in short I want to be able to for example: create an oblong box in corel draw, I have objects on the page that I want to nest
WEHAVE AN LARAVEL PROJECT BUILT AT 126.96.36.199. WE NEED TO CONFUGURE LARAVEL TO CONNECT TO MAIL SERVER AND ALSO CONFIGURE MAIL SERVER TO BOUNCE AND RESEND MAILS WITH MX RECORDS POITING TO ZOHO MAIL. CHECK: [login to view URL] WE WANT TO AVOID BLACK LIST. database of brands and models
...where it can be uploaded into our systems either in EDI or excel format. However, not all terminals in the world today are able to produce the TDRs in the TPFREP format, hence a number of locations worldwide are still sending their TDRs in their own formats. The task is to be able to write a VBA code to convert the TDRs from those terminals not able to
when user adds address in search bar results will display all vendors in his area or if user is logged in page will display all vendors in his area, if no vendors in the area it will say that good news: 1) search bar already created, code already created 2) geolocation code already created current developer has week of exams, so i need some one asap. If needed current developer can walk u throu...
1st attachment: 1. Get rid of "enable content" on opening, make a trusted workbook. 2. Add 4 offerings to a drop-down class menu. (I'll provide the additional information in more detail once hired) 3. Between columns 'AG' Add macro buttons or VBA for an interactive dynamic list of classes that prompt the existing dynamic calendars in the same way
Hi, I need to be able to fill a web form automatically with excel data, excel file contains basic info like names,address,email. I think it should be pretty simple for some of you.. let me know if you can do this and how long it takes,
...native language and there is another macro which saves invoice in pdf and excel new sheet. I need to make better logic for selecting invoice number, because it is not working ok .. (I will tell how). And there is a problem somethere, when I run macro which saves invoice excel starts not responding. Few days before it was everyhing ok. But now something
...measured individually. We use an Excel VBA script to generate a table from some input tables, which eventually is used for controlling a measurement robot. This vba script used to work fine with an old version of excel (5 years ago or so) but does hang or executes very slowly with new excel (2016, version 1807). The vba runs two nested for loops o...
1) Make my WordPress Website (look) better: [login to view URL] - looking for proposals with ideas including cost/time estimation and then implementation. As this website is not generating much traffic or any revenue, it should be cost effective. 2) I plan to buy a website in German language programmed in PHP (it is basically a database to find professionals), for this I would need to help to adju...
I need to get a Excel macro developed that can match two Excel files and find matching lines based on amount. The macro should then take all rows that it finds matching and list them under each other. and the ones it did not match it should line up in another column.
Write VBA program in excel that will automate the process for going through a library of MS Word documents and extracting specific paragraphs and tables from the Word Document and inserting the results into a excel spreadsheet.
I need you to designe/vba code a excel document that give a good overview of stock holding of personal equipment. The sugestion of a setup and how i want it to be can be seen in the excel document that are attaced. 1. overview over all registrated crew. 2. Profil can be added for each person and materila/equimpent etc. 3. It should be easy to work
Hello, I would like to receive quotes for someone to develop a spreadsheet in vba which would update prices. From some sites through their Api Olá gostaria de receber orçamentos para que alguém desenvolva uma planilha em vba a qual fizesse atualização de preç[login to view URL] alguns sites através de suas Api
...produces an excel sheet called the statement of accounts (screenshot attached). It is then printed out and handed to an employee in the legal department which has to manually key in the details from the statement of accounts to create the letter of demand which is sent to tenants. This process is time consuming and can be automated through VBA. Unfortunately
...phone numbers. It has to go and look at 3 other tabs to see if the exact match exhists. One of the tabs has multiple columns where it needs to check. What im looking for is VBA to: 1)Create a new tab and name it something of my choice. 2)Copys columns from all tabs identified and places them into essentially 4 columns with appropriate headers 3)A new
Column D is a Date and Time stamp that a ticket was entered. If the Date and time are between 17:01 and 07:5...ticket was entered. If the Date and time are between 17:01 and 07:59 or on a weekend we want to copy all of the data in that row to another sheet. I prefer this be done with a VBA Script but if it can be done using formulas I am ok with that.
The script in the attached [login to view URL] is used in Microsoft Access 365. It monitors the folder C:123 for new files every 60 seconds. When a new file is created there it displays a message box. I need code to that instead of displaying a message box will: - Load XML from an xml file created in that folder (ignore if file is not .xml) - Create a record in the table "ListOrdersRespons...