Vba macros optimization excel databaseработы

Фильтр

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

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

    $32 (Avg Bid)
    $32 Ср. ставка
    7 ставки
    Парсер для Exel Завершено left

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

    $32 (Avg Bid)
    $32 Ср. ставка
    4 ставки
    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 ставки
    Project for watersev Завершено left

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

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

    Нужно написать 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 ставки

    ...various reasons, Black cherry mx switches, usb passthrough, modular usb cable, but mainly because as far as i can tell it is the only keyboard in the world which is TKL and has macros (the roccat ryos pro tkl also does but they arent keys and are on the wrist rest and not the keyboard.) anyways, production started again earlier this year and i got mine fresh

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

    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.

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

    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 Ср. ставка
    26 ставки
    Excel VBA VLookup - Running too slow 4 дней(-я) 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

    $111 (Avg Bid)
    $111 Ср. ставка
    30 ставки
    Project for Akila K. 7 дней(-я) 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

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

    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) 4 дней(-я) 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 ставки

    I want the excel customized excel dashboard. The freelancer should have strong knowledge of advanced excel, macros and dashboards. Please bid only if you are the expert else do not waste the time. Thanks.

    $20 - $170
    Скрытый
    $20 - $170
    26 ставки
    I need the excel dashboard - -- Urgent 11 дней(-я) left
    ПОДТВЕРЖДЕН

    I want the excel customized excel dashboard. The freelancer should have strong knowledge of advanced excel, macros and dashboards. Please bid only if you are the expert else do not waste the time. Thanks.

    $20 - $170
    Скрытый
    $20 - $170
    14 ставки
    I need the excel dashboard - 11 дней(-я) left
    ПОДТВЕРЖДЕН

    I want the excel customized excel dashboard. The freelancer should have strong knowledge of advanced excel, macros and dashboards. Please bid only if you are the expert else do not waste the time. Thanks.

    $20 - $170
    Скрытый Соглашение о неразглашении
    $20 - $170
    5 ставки
    VBA Array processing 4 дней(-я) 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

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

    I looking for an individual to format a several word documents according to specific style specifications. I need several of these documents formatted so there is the...though, the document is extremely lengthy the document can be formatted fairly quickly by the use of find and replace function using wildcard variables and / or by the use of macros.

    $402 (Avg Bid)
    $402 Ср. ставка
    39 ставки
    Macros Excel 3 дней(-я) left

    Macro que depure base de datos en base a parámetros establecidos,.

    $38 (Avg Bid)
    $38 Ср. ставка
    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.

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

    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 ставки

    We need to transform an Input format into a desired Output format.  Ideally this would be done using Excel formulas, potentially using multiple staging sheets/tables.  However, if a solution can be found using VB Script/Macros/Web Add-Ins, it would also be acceptable. This proof of concept could lead to a much larger amount of work. The full brief

    $89 (Avg Bid)
    $89 Ср. ставка
    16 ставки
    Translate VBA in Excel to Javascript in G-Sheets -- 3 2 дней(-я) 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 2 дней(-я) 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 2 дней(-я) 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 1 день left
    ПОДТВЕРЖДЕН

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

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

    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 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 1 день left
    ПОДТВЕРЖДЕН

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

    $63 (Avg Bid)
    $63 Ср. ставка
    45 ставки

    Looking to hire a freelancer with expert level understanding and experience of Excel (Macros) to establish a new process of receiving invoice, tracking payments and implementing a response system for the fulfilled orders. You are: 1. Highly talented with Excel 2. Seasoned professional who understands either supply chain/supplier invoicing process

    $31 / hr (Avg Bid)
    $31 / hr Ср. ставка
    11 ставки
    exel macro and vba 18 часов(-а) 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

    $97 (Avg Bid)
    $97 Ср. ставка
    6 ставки
    Excel VBA coding Завершено left

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

    $108 (Avg Bid)
    $108 Ср. ставка
    37 ставки
    Excel formula help Завершено 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 Завершено 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 ставки

    ...coberturas - Considerar 14 sitios webs diferentes, con distintos niveles de complejidad y forma de mostrar la información Entregable: - Excel c/ Macros o similar, que genere una BBDD exportable a formato excel - Manual de uso de la herramienta y de la programación...

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

    I need a fully functional access database with queries, forms, reports and macros. My project is based on a Course Support System for a university called the Open Door Distance Learning University. I have already created my tables and relationships but that can be changed if you feel the need to.

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

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

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

    We have an excel model with macros that converts raw excel product detail data from suppliers to the format we need to upload into our store. We need to fix this model as it appears to have some bugs. For example, in the attached file "Dreamline..." file, the model populates column "A" (parent_sku) with values for SKUs that have no parent SKU (see and

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