Excel vba optimization functions jobs
Нужно создать инструмент для соединения двух таблиц. 1 файл *.xls - выгруженный отчет из 1с предприятие с номенклатурой товара. 2 файл *.csv - выгруженный отчет номенклатуры товара из битрикс. 3 файл *.csv - результат работы макроса. Необходимо соединить 1файл и 2файл по ключевому полю (код товара), с заменой цены, количества и названия товара. Выделить в отдельную таблицу уникальные зн...
Есть выгруженные данные *.CSV в Экселе, они идут через запятую. Нужно сделать парсер чтобы он он расставлял по ячейкам , как в примере. Можно написать как максрос или на VBA
Есть выгруженные данные *.CSV в Экселе, они идут через запятую. Нужно сделать парсер чтобы он он расставлял по ячейкам , как в примере. Можно написать как максрос или на VBA
I have some work, in an Excel spreadsheet. VBA макросы, работа на +-5 часов. Возможность выставления счета будет преимуществом.
Написать макрос, нумерующий все непустые строки в книге (.xlsx), на всех страницах, начиная с определённой и удаляющий лишние записи
Есть три файла (.doc) - спецификация, перечень элементов и руководство по эксплуатации. В руководстве по эксплуатации находится описание всех элементов, которые только могут быть в изделии. Необходимо написать программу, которая актуализирует руководство по эксплуатации. Пробегает по спецификации и перечню элементов и оставляет в руководстве описание только тех элементов, которые есть в спецификац...
Необходимо написать программу(макрос, скрипт) для импорта данных из таблиц Excel в таблицы doc-документа различных разделов. Подробности в личные сообщения
нужно написать программу для взаимодействия 3х листов в excel
...свой проект. Мы можем обсудить детали в чате. Я недавно вышел на новую работу и моей задачей является оптимизация и автоматизация имеющихся процессов (используется excel, word, необходим VBA). Проект имеет некоторые особенности в силу закрытости организации, поэтому ищу человека в Киеве. Бюджет обсуждается, сотрудничество может быть достаточно долгим
Нужно написать 10 простых макросов для ворд (язык VBA) Макросы необходимо реализовать в специальном файле, прикрепляю к заданию Примеры задач: 1. Заменить во всех словообразованиях от слова таракан первую букву на прописную 2. В тексте выделено слово. Выделить двойными кавычками все его вхождения в текст. 3. В тексте выделено слово.
Необходим макрос, который бы отслеживал значение стилей в Word'е и обрамлял их в нужные нам теги Данная тема обсуждалась здесь [войдите, чтобы посмотреть URL] и уже готова на 97%. Надо только всё привести в порядок Функции макроса: Исправление кодировки Обрамление Заголовков в теги h1, h2, h3, h4, h5, h6 соответственно
Необходимо написать группу макросов на VBA в книге EXCEL, в которой будет лежать соответствие названий файлов и нескольких колонок описания. По нажатию кнопки, макрос должен будет создать под учетной записью пользователя в сети VKONTAKTE, альбом с фотографиями из списка, при этом сделать подпись на картинках, состоящую из данных других колонок (через
Есть сайт построен на HTML - существующего функционала недостаточно. Нужно его переписать на PHP - сайт не информационный а представляет собой линчые кабинеты со статистикой и графиками. Наброски ТЗ можно посмотреть по ссылке: [войдите, чтобы посмотреть URL]
Есть сайт построен на HTML - существующего функционала недостаточно. Нужно его переписать на PHP - сайт не информационный а представляет собой линчые кабинеты со статистикой и графиками. Наброски ТЗ можно посмотреть по ссылке: [войдите, чтобы посмотреть URL]
...through the powerpoint when using section navigation through slides. Need sample code for powerpoint which hooks into navigation from slide to slide to be able to add logging vba code: - handling of slide names tages for logging - hooking into enter slide, leave slide, ... steps Details best clarified via chat. Will add additional information based on
I get data from an api. 99% of data is appearing only 1% is missing. the code had been working perfectly since a year. This error happened today. May be i deleted something? please check whats the issue and fix it. "Team Viewer" is important, I won't send the code file.
...Freelancers! We have an excel workbook which contains three sheets connect to each other using VBA. There are lists and buttons in the sheet which do have some associate functionality and ultimately reflects the changes in data tables. We would like to implement the same using trello power-ups API so that our users don't need to access the excel file. While bidding
Very simple requirements: 1) create excel vba code that will open a text file (e.g. [войдите, чтобы посмотреть URL]) 2) code will then do the following: 3) look for person's name in the line (e.g. Dr. FirstName Last Name) 4) remove the firstname and leave only Dr. LastName) 5) save text file without any further edits [войдите, чтобы посмотреть URL] - SHOWS YOU THE INPUT FILE (s...
Hello, looking for someone who can do form in access almost done with that just need to add some more work in it.
Can anyone write a script to automate data update/upload to ms project from ms excel. I have standard forms and need to update the project data through outlook inbox or by any other means.
...Opencart's theme so that it matches the designs that I've already created. *** I will send the .PSD to you, just ask me. 2. Add custom functions/pages to Opencart's front-end that match my designs. 2. Add custom functions/pages to Opencart's back-end that will make it easy for the admin to manage everything. 4. Implement ([войдите, чтобы посмотреть URL]) API t...
I’ll try to explain this the best I can. I want to setup 3 loops to pull data for college basketball games. I'm experienced in VBA but I'm having trouble creating a loop that does not error out after 15 games or so. There is some kind of security on the ncaa's site that prevents this type of data scraping I'm told. The workaround which has been mostly
MVC SQL WebServices skills is what I need at this time
Olá, Trabalho com varejo e atacado, venda de roupa feminina. Estou precisando de uma planilha em excel VBA, para otimizar meus processos de vendas e demonstrativos. Vi na internet muitas planilhas muito semelhantes a que eu preciso, precisando somente de algumas pequenas alterações, mas infelizmente quem as vende não faz alterações. a segu...
Hi i need a few things done for the adult video website. Please see below: 1. the categories on the video pages on the left is very long as there are many, so make them in a way that we can scroll it 2. using embedded videos from 3 party sites and when i click on the player to stop/pause etc.. it brings me to the original website. so i want to disable this. 3. show preview of each video when...
I need an excel vba expert to write a two phase code for me, with the first phase being to import data from two different workbooks based on a userform where a certain value is entered, and the second phase to import data from another workbook based on certain letters that are entered for the value talked about in the first phase
I am having a hard time creating a macro to ‘call’ a SharePoint. I am needing a VBA Excel macro code to ‘call’ a SharePoint so I can chose a file within the SP and have it automatically populate to a tab within the Excel spreadsheet.
i am looking for a programmer to addon Websocket (bi-direction communication) and Restful A...for remote controlling applications into my web based digital signage software We need the software to be able to perform the calling functions to monitor & restart the devices. samples codes for the calling functions will be provided, please see attached.
...alternate living) As it turns out we need a Video-Chat system ([войдите, чтобы посмотреть URL] or [войдите, чтобы посмотреть URL] alike). This application is an “outlet” part of our own products which are functions to run on top of such a system. Our products create interactivity between the models and the clients (compare with ex [войдите, чтобы посмотреть URL]). This part...
I need someone who is confident in writing efficient code and is willing to work for 2-3 days. Potential for constant work.
Hi, I receive constantly a data sheet that is always in the same format. The problem is that it is not a proper table and I need to amend it man...receive constantly a data sheet that is always in the same format. The problem is that it is not a proper table and I need to amend it manually. I would like to have a little VBA code that does it for me.
Requirement to create an excel configurator
hello everyone i need one website with all functions the simple is [войдите, чтобы посмотреть URL] or other sportsbooks websits if it is ready it is better or developing for payment just add crypto and perfect money and 2 more if you have demo of your works of betting website send me to see
...most completed one. And documentation [войдите, чтобы посмотреть URL] for full description. I would like to have a stopwatch APP for Android similar to this (Stopwatch/Timer is one of the basic functions of the application): [войдите, чтобы посмотреть URL] Some screens of the application I considered to be important, are attached
Для просмотра деталей, пожалуйста, зарегистрируйтесь или войдите в систему.
i have some work within vba macro expert with script .if you think you can do it ,bid it The rest of the words will be called Inbox, and the project details .my budget is low thank you
Hi, I am looking for a person who know how to make automatically ppt to vba
I would like to add data into Google Sheet from Solidworks. I'm using SolidWorks to make techn...data to Google Sheet and store files in Google Drive. I would like to have work done in two steps: 1. Populate new row in Google Sheet with data sent from Solidworks Macro (VBA, C#) 2. Save files to Google Drive and make link to the files in Google Sheet
I need some VBA code written to grab the FILL COLOR of a specific cell and then add all of the values that meet that FILL COLOR.
The site is: https://pubchem.ncbi.nlm.nih.gov/compound/Triasulfuron#section=Top Input will be a list of chemicals. You need to search for that chemical and extract the data in the attached format. Note that the download tab contains a list of files that need to be downloaded for each chemical. Out of this only the patents file needs to be downloaded for each compound. Please bid only after you ...
Hey! I am looking for a individual preferably from non Asian countries to develop my site. More info over chat!
i have some work within vba macro expert with script .if you think you can do it ,bid it The rest of the words will be called Inbox, and the project details . thank you
I need to loop through each row and for any cells that meet the "if" condition, then the cell value 6 columns to the left is displayed....to the left is displayed. I already have the entire code written that can email me the cell values, just needs small modification. Should only take 5 minutes for experienced VBA programmer. Need this done in 1 hour.
I have an already-developed app that needs to add a few functions. The app uses Back4app(Parse) as backend. The two main functions needed are 1. Messaging 2. Friend Request with few special features In addition you will have to display the user's and users's friends posts and information in multiple views (around 3). I don't want to spend anymore
We are searching for a experienced developer who has knowledge in both MS Access VBA and one other language such as Python/Rails/PHP. The goal of this process is to achieve the same functionality as before. Please don´t write a long list of accomplishments in your application but rather give me a short explanation how you would handle that problemset
download the data from sap and automate the report and share to all recipient.
I have a input excel file which i need to split into multiple excel files that i need. See attachment and video for more detail
want to have option in admin panel to create sub categories for sub categories as well. currently we have only option to create sub category for main category. so wanted the option to create nested categories option. also want to create location feature improved to track real location of poster. and some other features can be discussed in private chat.
We are searching for a experienced developer who has knowledge in both MS Access VBA and one other language such as Python/Rails/PHP. The goal of this process is to achieve the same functionality as before. Please don´t write a long list of accomplishments in your application but rather give me a short explanation how you would handle that problemset
