Excel vba code optimization jobs

Фильтр

Мои последние поисковые запросы
Фильтровать по:
Бюджет
по
по
по
Тип
Навыки
Языки
    Статус работы
    9,566 excel vba code optimization работ(-а,-ы) найдено, цены указаны в USD

    Нужно создать инструмент для соединения двух таблиц. 1 файл *.xls - выгруженный отчет из 1с предприятие с номенклатурой товара. 2 файл *.csv - выгруженный отчет номенклатуры товара из битрикс. 3 файл *.csv - результат работы макроса. Необходимо соединить 1файл и 2файл по ключевому полю (код товара), с заменой цены, количества и названия товара. Выделить в отдельную таблицу уникальные зн...

    $32 (Avg Bid)
    $32 Ср. ставка
    7 ставки

    Есть выгруженные данные *.CSV в Экселе, они идут через запятую. Нужно сделать парсер чтобы он он расставлял по ячейкам , как в примере. Можно написать как максрос или на VBA

    $25 (Avg Bid)
    $25 Ср. ставка
    17 ставки

    Есть выгруженные данные *.CSV в Экселе, они идут через запятую. Нужно сделать парсер чтобы он он расставлял по ячейкам , как в примере. Можно написать как максрос или на VBA

    $32 (Avg Bid)
    $32 Ср. ставка
    4 ставки

    Написать макрос, нумерующий все непустые строки в книге (.xlsx), на всех страницах, начиная с определённой и удаляющий лишние записи

    $23 (Avg Bid)
    $23 Ср. ставка
    4 ставки

    Есть три файла (.doc) - спецификация, перечень элементов и руководство по эксплуатации. В руководстве по эксплуатации находится описание всех элементов, которые только могут быть в изделии. Необходимо написать программу, которая актуализирует руководство по эксплуатации. Пробегает по спецификации и перечню элементов и оставляет в руководстве описание только тех элементов, которые есть в спецификац...

    $31 (Avg Bid)
    $31 Ср. ставка
    15 ставки

    Необходимо написать программу(макрос, скрипт) для импорта данных из таблиц Excel в таблицы doc-документа различных разделов. Подробности в личные сообщения

    $26 (Avg Bid)
    $26 Ср. ставка
    13 ставки

    нужно написать программу для взаимодействия 3х листов в excel

    $90 (Avg Bid)
    $90 Ср. ставка
    27 ставки

    ...свой проект. Мы можем обсудить детали в чате. Я недавно вышел на новую работу и моей задачей является оптимизация и автоматизация имеющихся процессов (используется excel, word, необходим VBA). Проект имеет некоторые особенности в силу закрытости организации, поэтому ищу человека в Киеве. Бюджет обсуждается, сотрудничество может быть достаточно долгим

    $150 (Avg Bid)
    $150 Ср. ставка
    1 ставки

    Необходим макрос, который бы отслеживал значение стилей в Word'е и обрамлял их в нужные нам теги Данная тема обсуждалась здесь [login to view URL] и уже готова на 97%. Надо только всё привести в порядок Функции макроса: Исправление кодировки Обрамление Заголовков в теги h1, h2, h3, h4, h5, h6 соответственно

    $15 / hr (Avg Bid)
    $15 / hr Ср. ставка
    1 ставки

    I have a spreadsheet data base of time entry which there is VBA code which creates a formatted Calendar and displays the hours worked by day on the calendar format. For any week that splits over 2 months, the total hours for the week are supposed to show in the following month. However, there is a bug in one of the months. I need someone to fix

    $145 (Avg Bid)
    $145 Ср. ставка
    18 ставки
    VBA Code for Form Filling, from an excel table 6 days left
    ПОДТВЕРЖДЕН

    VBA Code for Form Filling, from an excel table Hello, I'm needing a vba code that fills out a form on a page on my company's intranet. We are talking about a Human Resources sector In excel I have the personal registration(ID), name, note and description On the intranet page, the code needs to copy the excel personal registratio...

    $347 (Avg Bid)
    $347 Ср. ставка
    4 ставки
    Excel formula 6 days left
    ПОДТВЕРЖДЕН

    I need my excel spreadsheet finished with formula ,it cant be done with VBA or Macro because only formula is alowed .

    $33 (Avg Bid)
    $33 Ср. ставка
    76 ставки

    Phase 1: Data Staging from Stock Exchange file or API with applied calculations using Combinatorics. Output in webapp or excel

    $864 (Avg Bid)
    $864 Ср. ставка
    1 ставки

    Hello i need to calculate, in excel, many conditions and keep the profit margin at least 20%. The varibable are . Shipping cost . Product cost . Free shipping rate The product more cheap cost 1€/kg The markup is 50% The fix costs are 3€ The shipping cost depend from weight The free shipping is when order total is > 39€ The module is already done

    $26 (Avg Bid)
    $26 Ср. ставка
    15 ставки

    I need very simple code. But need it NOW. I have two tables "Quote Master Table" and "tblProposalStatus". Both have a field in it named "Quote Number". And there is a Field in the "Quote Master Table" named "Bid Status". Those are the exact names. (Note: I cannot change the names of the tables or fields, so please don't ask me to...

    $33 (Avg Bid)
    $33 Ср. ставка
    12 ставки

    Details will be shared with winning bidder. Please bid if you have develop vba for corel.

    $66 (Avg Bid)
    $66 Ср. ставка
    1 ставки

    Details will be shared with winning bidder. Please bid if you have develop vba for corel.

    $42 (Avg Bid)
    $42 Ср. ставка
    1 ставки

    Details will be shared with winning bidder. Please bid if you have develop vba for corel.

    $66 (Avg Bid)
    $66 Ср. ставка
    1 ставки

    Details will be shared with winning bidder. Please bid if you have develop vba for corel.

    $55 (Avg Bid)
    $55 Ср. ставка
    1 ставки

    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%

    $62 (Avg Bid)
    $62 Ср. ставка
    2 ставки

    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.

    $27 (Avg Bid)
    $27 Ср. ставка
    17 ставки

    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

    $192 (Avg Bid)
    $192 Ср. ставка
    3 ставки

    Hi i am good in excel vba macro. Request your support for getting good projects. I am new in freelanze and not yet done any project via this application. My no 9633314222

    $1 / hr (Avg Bid)
    $1 / hr Ср. ставка
    1 ставки

    Need a freelancer who can build my VBA application using Office Access 2016.

    $78 (Avg Bid)
    $78 Ср. ставка
    18 ставки

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

    $171 (Avg Bid)
    $171 Ср. ставка
    32 ставки

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

    $343 (Avg Bid)
    $343 Ср. ставка
    8 ставки
    Excel VBA Expert for automatic process 3 days left
    ПОДТВЕРЖДЕН

    I need to fill the form automatically with excel data.

    $24 (Avg Bid)
    $24 Ср. ставка
    38 ставки

    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,

    $90 (Avg Bid)
    $90 Ср. ставка
    10 ставки

    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

    $196 (Avg Bid)
    $196 Ср. ставка
    22 ставки
    $77 Ср. ставка
    3 ставки

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

    $117 (Avg Bid)
    $117 Ср. ставка
    29 ставки

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

    $160 (Avg Bid)
    $160 Ср. ставка
    19 ставки

    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.

    $21 (Avg Bid)
    $21 Ср. ставка
    24 ставки

    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.

    $126 (Avg Bid)
    $126 Ср. ставка
    32 ставки
    Excel docoument to keep track of equipement 1 day left
    ПОДТВЕРЖДЕН

    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

    $204 (Avg Bid)
    $204 Ср. ставка
    22 ставки

    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

    $170 (Avg Bid)
    $170 Ср. ставка
    11 ставки

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

    $120 (Avg Bid)
    $120 Ср. ставка
    36 ставки
    $38 Ср. ставка
    12 ставки

    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")

    $26 (Avg Bid)
    $26 Ср. ставка
    24 ставки

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

    $34 (Avg Bid)
    $34 Ср. ставка
    30 ставки

    Import export data from Microsoft word forms to sql server

    $13 / hr (Avg Bid)
    $13 / hr Ср. ставка
    25 ставки

    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.

    $125 (Avg Bid)
    $125 Ср. ставка
    12 ставки

    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]

    $22 / hr (Avg Bid)
    $22 / hr Ср. ставка
    5 ставки

    ...[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 "ListOrdersResponse"

    $24 (Avg Bid)
    $24 Ср. ставка
    5 ставки

    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.

    $23 / hr (Avg Bid)
    $23 / hr Ср. ставка
    7 ставки

    Hope someone can help. I'm writing an excel file in which, by entering certain data & values into pre defined fields, will ultimately create a list of products. We operate an e-commerce web site and often need to import products on mass. Our web site accepts csv's for importing the data. The data however has to be very specific & match 1to1

    $177 (Avg Bid)
    $177 Ср. ставка
    66 ставки

    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

    $464 (Avg Bid)
    $464 Ср. ставка
    18 ставки

    insert excel row data into PowerPoint slide vba in a certain textual format

    $26 (Avg Bid)
    $26 Ср. ставка
    43 ставки

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

    $31 (Avg Bid)
    $31 Ср. ставка
    8 ставки