Excel vba optimization functionsработы
Нужно создать инструмент для соединения двух таблиц. 1 файл *.xls - выгруженный отчет из 1с предприятие с номенклатурой товара. 2 файл *.csv - выгруженный отчет номенклатуры товара из битрикс. 3 файл *.csv - результат работы макроса. Необходимо соединить 1файл и 2файл по ключевому полю (код товара), с заменой цены, количества и названия товара. Выделить в отдельную таблицу уникальные зн...
Есть выгруженные данные *.CSV в Экселе, они идут через запятую. Нужно сделать парсер чтобы он он расставлял по ячейкам , как в примере. Можно написать как максрос или на VBA
Есть выгруженные данные *.CSV в Экселе, они идут через запятую. Нужно сделать парсер чтобы он он расставлял по ячейкам , как в примере. Можно написать как максрос или на VBA
Написать макрос, нумерующий все непустые строки в книге (.xlsx), на всех страницах, начиная с определённой и удаляющий лишние записи
Есть три файла (.doc) - спецификация, перечень элементов и руководство по эксплуатации. В руководстве по эксплуатации находится описание всех элементов, которые только могут быть в изделии. Необходимо написать программу, которая актуализирует руководство по эксплуатации. Пробегает по спецификации и перечню элементов и оставляет в руководстве описание только тех элементов, которые есть в спецификац...
Необходимо написать программу(макрос, скрипт) для импорта данных из таблиц Excel в таблицы doc-документа различных разделов. Подробности в личные сообщения
нужно написать программу для взаимодействия 3х листов в excel
...свой проект. Мы можем обсудить детали в чате. Я недавно вышел на новую работу и моей задачей является оптимизация и автоматизация имеющихся процессов (используется excel, word, необходим VBA). Проект имеет некоторые особенности в силу закрытости организации, поэтому ищу человека в Киеве. Бюджет обсуждается, сотрудничество может быть достаточно долгим
Есть сайт построен на HTML - существующего функционала недостаточно. Нужно его переписать на PHP - сайт не информационный а представляет собой линчые кабинеты со статистикой и графиками. Наброски ТЗ можно посмотреть по ссылке: [войдите, чтобы посмотреть URL]
Есть сайт построен на HTML - существующего функционала недостаточно. Нужно его переписать на PHP - сайт не информационный а представляет собой линчые кабинеты со статистикой и графиками. Наброски ТЗ можно посмотреть по ссылке: [войдите, чтобы посмотреть URL]
...automate tasks in Excel by writing so-called macros. This is for a project repeated every 3 months. Attached are the spreadsheets we have put together. I also attach the end result which gets fed through the excel information. We take the financial statements for ten banks in one given country. We then input all info on to the excel model. Only on the
The project is to develop some new functionalities on an existing developed Mobile Application with Admin Panel. The whole application platform is built with different frameworks: - IONIC for Android - SWIFT for iOS - PHP with Laravel framework for a Mobile Web & Admin Panel and MySQL DB. The new functionalities including an ordering system for different users. A wireframe of the project...
we have a database in Microsoft Access and we want relied this a management planning for our drivers. please disc...Microsoft Access and we want relied this a management planning for our drivers. please discuss in private for more details not need you share with me your other skills, I want only VBA developer and if you share other skills I not reply
I need a VBA script that will use the spreadsheet and create outlook emails that will send to each individual recipient listed. Example email body: Hello, I see that PO# (value from spreadsheet) was not picked up yesterday. Can you please advise if this freight is ready for pickup today?
I need an Android app. I already have a design for it, I just need it to be built.
Some bugs to fix for a printing label VBA software
We have an input sheet with multiple columns where each contains number of alphabetic variables ranging from 7 to 60. Objective is to create various permutations of those values by combing values between certain columns using a specific logic with a number of conditions and exceptions. For example: combined values from columns A, B and C except if a value in column B=X, then only pick values fro...
We have an input sheet with multiple columns where each contains number of alphabetic variables ranging from 7 to 60. Objective is to create various permutations of those values by combing values between certain columns using a specific logic with a number of conditions and exceptions. For example: combined values from columns A, B and C except if a value in column B=X, then only pick values fro...
Microsoft Access 2016 database using vba script to drag and drop files from MS Access 2016 listbox to Windows Explorer and Microsoft outlook 2016 message. The files listed i MS Access listbox to be dropped into Windows Explorer, all selected files shall be copied to the dropped location and selected files to be dropped into newly created message in
Need someone expert in Excel. I have an excel file and i want to translate it in English. Also it downloads data from web, and i need to have it online, so i need to transform it into a googlesheet file.
adding multipage and adding a new function
We have an input sheet with multiple columns where each contains number of alphabetic variables ranging from 7 to 60. Objective is to create various permutations of those values by combing values between certain columns using a specific logic with a number of conditions and exceptions. For example: combined values from columns A, B and C except if a value in column B=X, then only pick values from ...
A Freelancer with strong skill in C++ is needed to add features to an existing code for handling a vector container. This is referred to as a buffer. It handles text file data as line entries into the buffer. This will need to be compiled with the OpenWatcom compiler and the DOS32 extender.
I have a macro to be fixed. It was done by some one else but its not working perfectly as i wanted. Thanks
Hi, I have a VBA code written in excel file (macro). It performs the calculations. I will provide you the code and I need someone to provide detailed description for each line of the code. (eg. how code works, what each line does, what each line means etc.)
Must have the ability to create functions that interact with wp jobs manager.(This is important if you do not already know wordpress jobs manager it will be extremely difficult to explain the tasks I need) Want to integrate plugins with the site using the 'job_manager_update_job_data' function Looking for an experienced php/wordpress developer. If things
Help with fixing 3 python functions easy code beginner. I don't want no expert code just fixing my code and things I can understand and learn from.
...Store: Need some custom Functions. The main function needed is a Text editor on certain product pages or products pertaining to certain categories and once the text is saved, we need a way to save it to the back office to be able to copy and paste the entire text that was saved from the front end. There are a few other small functions needed as well. Coder
Job details will be provided later. Hourly job. Please bid only if you are free to work from today.
I have an advertising network script built in core PHP and I'm looking for a full-stack PHP developer to create some extra functions and re-write certain parts of the website into PHP 7.2. I also want to replicate the current design into bootstrap & create some new pages.
tengo un listado en una columna de excel y deseo eliminar los saltos de linea de cada celda reemplazarlos por el simbolo "/" para que quede en una sola linea resumiendo: 1- eliminar el texto "Volver al listado" 2- reemplazar los saltos de linea entre palabras y reemplazar por un simbolo "/" EJEMPLO del contenido de una celda: Volver al listado
I just need a form where I can enter details and that should be added to my access database, it's very simple. You should only use VBA code in MS Access, no other language or inbuilt feature of MS Access. I will give you all the table related information
I have an integral of the Fourier type to be evaluated. I bumped on it while making research in plasm...have an exact form so it needs some kind of approximation, either polynomial or other. I show the integral, and later I can show some solution (which includes some special functions) so the solution you will develop should have about a similar form.
Need VBA to sum numbers. First, the VBA looks into column B to identify product category. After it looks into column D. In column E it creates the sums with a MAX value of 800. As you can see on the picture we have many sums within the same product category.
Hi there! I have been working on an excel vba macro that transfers data from one workbook to another. The part that I am stuck on is how to transfer several rows of data from one workbook to another and at the same time setting things up so the next time data is transferred, it will go under the previously transferred data. The majority of the macro
We want to create a selection program in Excel that sends dimensional parameters to dwg files to modify drawings according the Excel output parameters. In the attached example, we might want to change four dimensions, currently "800 Channel", 1080 (vertical dimension, middle of drawing), "1067 (25% BLINDED)", and "1008 (CLEAN)". We would want the
I need a Visual basic expert for my current projects. If you have knowledge please bid. Details will be shared in message with the f...a Visual basic expert for my current projects. If you have knowledge please bid. Details will be shared in message with the freelancers. Please bid if you have experience in VBA. Project will take max to an hour
...even consider your offer. I have written a complicated pricing program in Excel and need assistance finishing it. For this moment you are bidding on debugging the macro "Building 1" Located on the "Quote" Worksheet. The winning person will: *Have advanced knowledge of Excel. *Be able to start immediately *Be available for hourly work over the next
The backend developer need to perform particular tasks like 1. While signing up user, user details have to be saved in the database. (and should add each functionality whatever in the website) like categories, products, payment gateway everything should be added in the database we use this API for application building 2. If suppose the registered user like to log in from an application the PH...
Desired output is an Excel (Mac Version 14.7.7) spreadsheet which prioritizes restock from vendors by sales volume and/or profitability. Inputs are two data files exported from Quickbooks ("sales" and "stock") which are attached. Note that these data export files can be modified to some degree if required. Also, "sales" data file includes data for all
I need a faster VBA macro. It's important to mention that the data I intend to scrape needs expanding to view the data required. It's like vertical tabbed content if you will. XML http is faster you can use it or other way but goal is fast vba. Apply if you can deliver this and pls do so within my budget.
Need regular assistance with VBA excel
For this project you must have a HTC Vive integrate some functions to a web page. That you can find here, ([войдите, чтобы посмотреть URL]) The functions I want to implement are as follows. WebVR already works but there is an angle of the camera that I can not correct in the glasses. Dragging (https://threejs
I want to add the ability to send a message to mailchimp api when a new user is added to the firebase dB for my app. It’s on github.
Extent map plugin functionality and connect it with the travel user front end dashboard in a activity booking theme !
I need a XXXXXXXXX expert for my current projects. If you have knowledge please bid. Details will be shared in message with the freelancers.
Create a VBA macro for import data to excel. Data from link on website.
add a data save function to EA and 1 other simple function
I need a XXXXXXXXX expert for my current projects. If you have knowledge please bid. Details will be shared in message with the freelancers.
