Excel vba optimizationработы

Фильтр

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

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

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

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

    $25 (Avg Bid)
    $25 Ср. ставка
    17 ставки
    Do some data entry Завершено left

    I have some work, in an Excel spreadsheet. VBA макросы, работа на +-5 часов. Возможность выставления счета будет преимуществом.

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

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

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

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

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

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

    $26 (Avg Bid)
    $26 Ср. ставка
    13 ставки
    Excel Vba data analysis Завершено left

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

    $90 (Avg Bid)
    $90 Ср. ставка
    27 ставки
    Работа в Excel Завершено left

    контрольная работа по VBA excel

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

    Система должна быть создана в VBA Excel. На основе таблиц с прогнозами информирует закупщика о необходимости размещать заказы для пополнения запасов.

    $144 (Avg Bid)
    $144 Ср. ставка
    16 ставки

    Нужно написать 10 простых макросов для ворд (язык VBA) Макросы необходимо реализовать в специальном файле, прикрепляю к заданию Примеры задач: 1. Заменить во всех словообразованиях от слова таракан первую букву на прописную 2. В тексте выделено слово. Выделить двойными кавычками все его вхождения в текст. 3. В тексте выделено слово.

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

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

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

    Необходимо написать группу макросов на VBA в книге EXCEL, в которой будет лежать соответствие названий файлов и нескольких колонок описания. По нажатию кнопки, макрос должен будет создать под учетной записью пользователя в сети VKONTAKTE, альбом с фотографиями из списка, при этом сделать подпись на картинках, состоящую из данных других колонок (через

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

    I want to create a scoreboard that can be changed when using PowerPoint on an iPad and on a MAC. Not sure if macros / VBA will be the best way. But it needs to be able to go up and down by hundreds.

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

    I would like someone to write a macro for me that can read an JSON file from a directory and parse the data into a readable worksheet. I will attach a file as I have many of them on my computer.

    $43 (Avg Bid)
    $43 Ср. ставка
    22 ставки
    Excel VBA VLookup - Running too slow 5 дней(-я) left
    ПОДТВЕРЖДЕН

    I have a project with Excel vba vlookup that needs modified. The tables are large and the vlookup is very slow. When I read documentation, the suggestion is to use a double vlookup, which I am not able to get the syntax right,. This is the line that is working, but slow: LookupResult = [войдите, чтобы посмотреть URL](LookupValue, LookupRange

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

    VBA programming for an already prepared excel-folder. See commentary in the attached excel-folder (sheet "ZZZ": A4, B3, C5, E5, F5 and in sheet "aaa" A3)

    $71 (Avg Bid)
    $71 Ср. ставка
    18 ставки
    Programare excel (VBA) 5 дней(-я) left

    Vreau sa creez o funcție (VBA) care sa convertească un fișier txt în Excel la apasarea unui buton. (function)In acelasi timp sa se poata Introduce manual calea de unde se ia fisierul txt respectiv, unde va pune fisierul excel, anumite informatii adaugate manual. Am anexat mai jos cum arata fisierele text (2 tipuri de format) si de asemenea cum trebuie

    $212 (Avg Bid)
    $212 Ср. ставка
    5 ставки
    VBA Array processing 5 дней(-я) left

    I would like to hire an Excel Expert to correct a faulty Excel VBA Sub. I want to 1) Transpose a column to a row, 2) Multiply that row times a conforming matrix, and 3)Transpose the result to a column. Attached is an Excel spreadsheet with some data and some defined ranges. It contains a macro triggered by the only button on the spreadsheet. There are

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

    The idea is creating a list of companies and the primary key is the registration number with the ability to amend the list or create a new list. and then to import excel files contain a large list of companies and in case one of the companies were inputted in the before it showed show as red flag. (More like a vlookup table) So, we will have two interfaces

    $171 (Avg Bid)
    $171 Ср. ставка
    19 ставки
    Excel to Word Mail Merge 4 дней(-я) left

    Excel to Mail Merge if certain records selected to print than to mail merge certain records to word. Needs to be automated in vba.

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

    Boa tarde, O meu nome é Gil. Estou á procura de alguém que faça um ficheiro excel para controlo de produtos. As funções que gostava que tivesse, são: Tabela de produtos, inserção de produtos na tabela, remoção de produtos na tabela e consulta de produtos através de filtro.

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

    Here is everything you need to understand in the video: [войдите, чтобы посмотреть URL] Please see attachment which contains all the files you'll need to get started Here is a link to access all the files: [войдите, чтобы посмотреть URL] Let me know if you have questions, Thanks, Jai

    $95 (Avg Bid)
    $95 Ср. ставка
    16 ставки
    Charts and reports in Access DB 3 дней(-я) left
    ПОДТВЕРЖДЕН

    Hello, I need Some reports to create in Access DB using SQL queries or vba. Based on that sql queries need to draw charts to display the data in charts.

    $48 (Avg Bid)
    $48 Ср. ставка
    25 ставки
    Translate VBA in Excel to Javascript in G-Sheets -- 3 3 дней(-я) left
    ПОДТВЕРЖДЕН

    I have a spreadsheet in excel with a set of macros and buttons written in VBA that i want to convert to google spreadsheets, where macros should be written in Javascript. The file is attached.

    $57 (Avg Bid)
    $57 Ср. ставка
    6 ставки
    macro Excel vba development 3 дней(-я) left

    I need you to develop some software for me. I would like this software to be developed for Windows using SQL.

    $14 / hr (Avg Bid)
    $14 / hr Ср. ставка
    6 ставки
    simple excel vba program 3 дней(-я) left

    Currently I am updating my personal program using excel manually. Since i have no knowledge using VBA

    $93 (Avg Bid)
    $93 Ср. ставка
    29 ставки
    convert excel file to exe 3 дней(-я) left
    ПОДТВЕРЖДЕН

    convert excel file that contain VBA to exe with password to protect the formula and protect VBA

    $20 (Avg Bid)
    $20 Ср. ставка
    20 ставки
    MAC VBA macro to move files 2 дней(-я) left

    Urgent - VBA Mac Not Windows - I need a VBA macro to run on MAC to search a folder and all its subfolders for a combination of files like excel and word files and copy all files found to a new folder. Your code MUST run on MAC.

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

    Want to get done a spreadsheet using Macro and VBA for sending emails via outlook for list of recipients.

    $86 (Avg Bid)
    $86 Ср. ставка
    8 ставки
    Simple 15 minute VBA project 2 дней(-я) left

    Simple 15 minute Excel VBA project. Push a button and it puts a name which is typed in into a list and clears the field for the next name to be input.

    $26 (Avg Bid)
    $26 Ср. ставка
    18 ставки
    VBA data entry 2 дней(-я) left
    ПОДТВЕРЖДЕН

    Using VBA and FORM in Excel to build data entry with option buttons. 2 days

    $63 (Avg Bid)
    $63 Ср. ставка
    44 ставки
    exel macro and vba 1 день left
    ПОДТВЕРЖДЕН

    I need a programmer. I had an excel file of renters for a residential & commercial building. I prepare this file monthly. It consists from columns with Flat numbers, it’s kind (residential or commercial), renter name and rent And the era paid for rent at its time it is in Hijri calendar from...to... You can get and update all information from last month

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

    as like CRM, complete sales solution from customer entry to dispatch

    $98 (Avg Bid)
    $98 Ср. ставка
    6 ставки
    Excel VBA coding 8 часов(-а) left

    I have some work, in an Excel spreadsheet. Need a quoting system build in excel, using our data base

    $109 (Avg Bid)
    $109 Ср. ставка
    36 ставки
    Excel formula help 8 часов(-а) left

    Summarising data from table onto new sheets in specific formats. All formulas no VBA.

    $20 (Avg Bid)
    $20 Ср. ставка
    22 ставки
    Word 2016 Templates And VBA 7 часов(-а) left

    I'm looking for someone who can create VBA Word 2016 templates for a law firm, based on our needs as they come about. We have current small access db, that some of our templates pull from, that can be used when needed.

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

    ##Advanced VBA skills and high experience automating excel will be needed to understand the code written so far, debug and complete the work according to spec## A VBA programmer has done most of the work according to the attached Statement of Work, however due to personal issues he has not been available in weeks to complete the work. This has been

    $111 (Avg Bid)
    $111 Ср. ставка
    43 ставки
    Excel VBA for Business Завершено left

    Customers, Agents, Sales, Inventory, Reports, schedule, time in time out .... and more in excel

    $405 (Avg Bid)
    $405 Ср. ставка
    46 ставки

    Excel Macro VBA - assistance with VLookup in VBA Hello The purpose of the macro is to process each row, and when there is a certain condition, correct the entry in the cell. I am using (attempting to use) VLookup to access the values in the 2nd sheet and correct the values in the first sheet of the workbook. Receiving the following error when running

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

    build a macro which will copy data from one excel workbook to another. for each row in one excel file the macro should create two lines in the other excel workbook. in the column A of the new file CA should be written in the first line and SL in the second one. also in column E should be filled with text "y" as many as rows

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

    I am looking for an Excel VBA programmer. I need to develop a Warehouse Management System in Excel with the help of VBA programming. The task is to setup a Master-Data file (Excel) that should function as a database. I need you to create an excel for every team where they are able to store data in Master-Data and retreive information from the Master-File

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

    Hello, I want to streamline some tasks for my colleagues so I want them to be able to do three things using separate buttons on an Excel sheet. I can do the buttons and attach the macros but writing the macros seems to be beyond me. I need as follows: From one button: Save a template .xlm file as a new file in a specified location with the file

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

    I am interested in having an automated calendar creator with vba code combined with multiple task calendars. Essentially someone should be able to copy multiple calendar task sheets into one excel workbook organize the columns in a standard format. The format being "Deal Name", "Task & Description", "Key Date", "Organizer", and "Commen...

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

    I have got a VBA Macro for Ms Excel coded by a VBA Expert. I want some changes in it, need to delete something & add few new contents. It should be a simple project for an expert so lowest bids will win this project.

    $69 (Avg Bid)
    $69 Ср. ставка
    20 ставки
    MS Access Database Завершено left

    MS Access Database VBA Code to program Database to make query routine and function

    $354 (Avg Bid)
    $354 Ср. ставка
    60 ставки

    ...you-------- -----------------PROJECT DESCRIPTION: I am interested in having an automated calendar creator with vba code combined with multiple task calendars. Essentially someone should be able to copy multiple calendar task sheets into one excel workbook organize the columns in a standard format. The format being "Deal Name", "Task & Description", "...

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

    Advanced VBA needed in 24hrs

    $189 (Avg Bid)
    $189 Ср. ставка
    13 ставки
    Advanced VBA needed Завершено left

    VBA programming, auto graphing and data sourcing needed

    $182 (Avg Bid)
    $182 Ср. ставка
    4 ставки
    Small Excel VBA Project Завершено left

    Hello, I have a small Excel VBA project to be completed. Data is not large but needs to just be automated to fill data to a template. Need a good knowledgeable person to help me out. I will send the files later. Need this to be done around this weekend so you need to be available then. Budget -10$. Any bids for excess value will not be considered. Thanks

    $16 (Avg Bid)
    $16 Ср. ставка
    31 ставки
    Fix access database Завершено left

    Hi, if you are an expert with VBA, access and word, this project will be very easy for you. I have a * very small and basic* invoice database with client, invoice and billing tables set up and need some functionality, user interface and reporting added to it: Functionality Each "client" entry has multiple invoices and each invoice has multiple billing

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