Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using
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.
Our online store is Prestashop based. We receive product information and product details from our suppliers in Excel sheets. Those excel sheets are in all different formats, but we want to align too the import format for Prestashop so we can easily automate the import. Some need small adjustments and some need some more work.... Show us what you
I'm looking to create a google sheets-based calculator for the purpose of computing numerous factors from an online game that I play. The spreadsheet is 99% done, but I'm completely stuck on the last part. Essentially what the calculator does is compute the total cost and in-game "happiness" level based on which property and which individual property
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 = [kirjaudu nähdäksesi URL:n](LookupValue, LookupRange
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
I'm looking for an artist who can articulate a few character ideas into concept art and model sheets for my upcoming game I'm personally making. I don't need/want highly detailed drawings but instead, I want the bare minimum for what is needed to create these models in blender.
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
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
In eed a function which will compare the contents of a cell C2 with the contents of column A. Then in a list I want some information to appear. 1, How many words from cell C2 exist in Column A. How many words from cell C2 exist in column A and are marked as "english 1" in column B. Then how many words from cell C2 exist in column A and are marked as "english 2", "english 3...
We are looking at modernising an existing company logo. Mastery is an almost 5 year old company where the logo needs refreshing. The Bones of the logo are there but it needs tweaking and refreshing to reflect "clean lines and simplicity" Brief- Have a Company logo that can just stand alone with the Letters MC which stands for mastery Constructions and Mitch Chilton (director) and it will...
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.
Here is everything you need to understand in the video: [kirjaudu nähdäksesi URL:n] Please see attachment which contains all the files you'll need to get started Here is a link to access all the files: [kirjaudu nähdäksesi URL:n] Let me know if you have questions, Thanks, Jai
We are looking to hire a partner to do a complete website refresh. For competitive purposes, we will only share the company name & content after we have selected & met via conference call with a developer. We have all the content built into a word document, so once the layout and site is built out, the content will be simple to move over. We also have
A series of Google Forms, Google Sheets which allow for creation of quotes, creation of works orders, creation of purchase orders and logs that track each item.
Octoparse API provides data extraction on schedules, once per day the data from many different tasks should be transferred to google sheets, updating the same with the new data. The API connection should be made in a way that can be easily edited and reuse it in the future with new tasks and spreadsheets. It is important for me to understand the process
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.
USONICIG is a new groundbreaking brand in vaping market. Innovative Ultrasonic Vaping Technology different USONICIG from all other e-cigarette brands. We established our official website recently, and need you to polish the copywriting, including product and tech introduction, marketing bullets writing and brand story. Please see our web before bid: [Removed by Freelancer.com Admin - See Section 1...
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
Hi, need to change some things on website. Most of changes are simple, some new things to add, change of footer design etc... site is on wordpress with custom made template. Also we need to integrate BOKUN booking widget, now we use Woocommerce
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.
I am looking for a Excel Online Developer who can help me load some excel tools (workbooks) that have data connected to a SQL server that refresh when opening. I am attaching one file as an example. Also, if you are a Sharepoint expert that would be great.
...user viewing it. This is a lot of database pulls. What I need done: Create a function that detects when a new message is sent. Alert the user client and backend client to refresh and grab the new messages. These changes should not effect the performance or experience of the chatbox. I will be able to supply the full plugin files once a developer is
i want to create automated VBA macro to extract information out of multiple thousands PDFs. Rest detail are attached . please review it and place a bid . thanks.
- Google Sheets expenditures tracking and management tool
##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
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
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
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 ...
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
Use the script here: [kirjaudu nähdäksesi URL:n] and extend it to automate the capture of the variables from the 'item posts' sheet here: [kirjaudu nähdäksesi URL:n] and put them into a new copy of the template here: [kirjaudu nähdäksesi URL:n] I've already started the modification of the script here: [kirjaudu nähdäksesi URL:n] but got stuc...
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 "...
Looking to scrape data from our current site and organize the compiled data into 2 excel sheets. We also require to download all images and match those image in the sheet. Please PM for sample output template and site to pull data from. Thanks
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.