Vba optimization jobs
Jeg skal have sorteret forskellige studerende på nogle kurser, som de hver især har rangeret. Ikke alle kurser kan have alle de studenter der søger, hvorfor dem med størst præference skal fordeles hertil. Der skal ligeledes udarbejdes en userform, da der er flere dataset at vælge imellem.
Details will be shared with winning bidder. Please bid if you have develop vba for corel.
Details will be shared with winning bidder. Please bid if you have develop vba for corel.
Details will be shared with winning bidder. Please bid if you have develop vba for corel.
Details will be shared with winning bidder. Please bid if you have develop vba for corel.
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%, copy A4:E4 to outlook loop G col for ev...
Extract data from a website with pagination. Need to get the data to Excel file. Not a complex data extract, but ...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
Need a freelancer who can build my VBA application using Office Access 2016.
...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 support TPFREP, into the standardized TPFREP template (either in excel or EDI formats). To do this, the macro must
...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 the drop-down class menu already does. Can have list print on second page
I need to fill the form automatically with excel data.
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,
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
I have data register, which I need to make better. It generates invoices with words in my 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 ...
...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 over two
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
...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, a simple mail merge will not work as the system generates new excel sheets for each tenant Essentially, we need to create a mail merge, but with dynamically
Need expert on vba and macros on backend coding
I need VBA code for an excel formula that I want to be able to save within Excel formulas i have =EXTRAE(A2;1;6) and another =TEXTO(G2;"000000")&TEXTO(F2;"0000")
...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
Import export data from Microsoft word forms to sql server
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.
Thanks for your interest. Would like to talk to you to discuss my needs. Please reach out to me ar /> [REMOVED BY FREELANCER.COM ADMIN - PLEASE SEE SECTION 13 OF OUR TERMS AND CONDITIONS]
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...
...Categorize Library and upload products (from excel csv upload. This may include 20k to 30k products. It may require you to clean and edit data so you should have excellent Excel and VBA skills) • Find and edit images we may require • Install any appropriate addons/plugins • Help find acceptable payment system • Carry out and prepare a user acceptance test Requirement...
We need someone to help writing the code for an TDS3034, controlled by VBA 2015 USB, we are using the community version. We need to get the waveform and get some information from it in order to determine pass/fail criteria. You should be able to read voltage/current configure the scope depending on the expected parameters.
...in correct format ready for import into our system. I've already built all the pre-defined fields. I already know the output I require. I am however not able to write VBA myself & therefore stuck at the next stage. THE 1st STAGE Basically the data is entered into the fields in rows 1:45. Then an 'ADD PRODUCT' macro button is pressed.
Hi, I need to rewrite Word VBA script into Google Docs script. The script must perform these 3 actions 1 / The word document is segmented into bookmarks (ie: Chapter1, Chapter2 .., Chapter11). On the first page of the Word document there are 11 checkbox allowing to select or not the display of these chapters. 2 / On the first page there is also a table
insert excel row data into PowerPoint slide vba in a certain textual format
...information about properties in Mohave County, AZ. Entering the Parcel number in the website and manually typing everything into excel would be tedious. So I need someone to write a vba code that will do that for me. The attached excel sheet has the website and the columns represent the information that I need. I need it to loop through all the parcel numbers
The purpose of this project is to demonstrate your knowledge of management science techniques, your understanding of VBA coding, and ability to develop a DSS system.
Proofreading and editing write-ups Create macros using VBA scripting with various files
Proofreading and editing write-ups Create macros using VBA scripting with various files
Hi Vba A., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
1.) Export a table from Excel to acces Note: One table contains Project data of one month 2.) The table contains 29 Columns 3.) The unique identifier (UID) consists of 8 columns . 4.) If Project data of the corresponding month exists -> replace the existing record set. Note: Data exists if "Jahr" &"Monat"&"PSP" match Ideas exist to enhance t...
I need a small VBA program that should provide a option to select the Excel file which contains events data. Then the tool should access Outlook Calendar and import events into it.
Complete the programming instructions in the attached word document using excel files that will be provided. Must be able to complete in 24 Hrs.
NOTE: The code needs to be written INSIDE ACCESS (In VBA). I have stored client information in an MS Access database, and would now like to populate a PDF FORM from MS Access and send it to my clients and ask them to update their contact information. When they send me the updated file, I want to be able to update the data in my database as well. So
HI. I need simple VBA script for Excel. I need excel file with two columns - Barcode and Quantity Functionality: #1 Create Income button. On click it will show textarea popup - there I will enter list of barcodes. On Click OK - Script will search each barcode in "Barcode" column - if it exists it will increment Quantity column, if not exists -
Hi, I am looking for the following functions to be added to my VBA spreadsheet: 1. Amend my stopwatch counter code so that it starts and runs without having to have the sheet selected (currently, if I am not on the sheet, it doesn't run, and if I am on the sheet and it starts, it creates an error when I leave to click onto another sheet); 2. Amend
Hi there, Have a very simple macro, which outputs to spreadsheet. I want a c# version which makes a CSV. It's only data - no Excel-type methods are used in the VBA program.
I have a data analysis task. Data Analysis, Business Analysis, VBA, Tools Development, PPT Presantion, Prepare Daily,Weekly, Monthly MIS Report
...Excel and can use it to develop an exam which has 21 sample questions. Some questions types are simple while others are graphical questions. knowing Excel programming may help (VBA). The Exam scores should be retrievable. NOTE: If you know how to integrate Excel exams with Learning Management System (LMS) tell me about your background about it. Find
