Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the 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 available and the Project needs to be done using
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 need some help with API connectivity to 3 cryptocurrency exchanges. The following functionality in excel VBA needs to be created: 1. Get live price data (bid, ask, sizes of bid and ask) for selected crypto currencies - including depth of the market 2. Live price data collection and archivation. 3. Ability to access archived data. 4. Get cash
Already built site, [kirjaudu nähdäksesi URL:n], has to be moved to another provider I have already selected. New hosting provider gave this information:- Dear John, Thank you for getting in touch with us. The following is an overview of the process :- 1) Purchase hosting suitable for Word Press 2. Export data from existing provider (files and database) 3. Guide about
Hi there, I am looking for an expert with Google Sheets. It is about automatic web scrapping from different websites into Google Sheets. Script needs to fetch data every few hours automatically. NO PYTHON - I want everything to happen in Google Sheets (G Suite-Plattform). PRICE - MAX. 30EUR
I'm looking for someone who is expert on google sheets to make graph and statistics
Hi there! I have a project which requires someone with skill in HTML. I want to send an automatic email to my customers, which will have this star rating. [kirjaudu nähdäksesi URL:n] I want my system (Netsuite) to be able to put the customer's order number and name and email address into the HTML of the star rating, and send an email to the customer with this star rating with the c...
Hello, I require an excel expert to work on an existing excel sheet. You must have an excellent knowledge of Excel VBA, Macros and add-ins. The sheet already contains a lot of existing code which has some bugs which need to be fixed. The main part of the project is to create an add-in for mapping. This need to be dynamic. It needs to map the values
We add data into the RWN MICS file (employees, sales companies etc) as well as the RWN BDM file (what commission our company, sales companies and our sales consultants receive per project) – this is only done once a new employee starts or new projects get releasedWe input data into the RWN DEAL PROGRESSION – Master file on a daily basis with a row per [kirjaudu nähdäksesi URL...
...[kirjaudu nähdäksesi URL:n] Functions imports events from google calendar and parses the data into time sheets, then calculates distances from addresses. Here is a sample calendar with test events in December 2017 and January 2018. The sheet is linked to the test calendar: https://calendar
I need vba that will autofill and autoclick through the creation of a Salesforce opportunity. You don't need to know anything about Salesforce. Take csv data in worksheet and fill fields, click buttons to move to next screen, etc..
...how to use APIs in Google Sheets. I would like to create a Google Sheets document that pulls from multiple API sources, but I don't know how to set this up or set up the connection to these APIs. I'm looking for someone to show me how to manually set up one of these API data pulls to get some sample data into Google Sheets. You will remote into my computer
i have a google sheet file/scripts that are currently quite buggy. i want to create a modification that should eliminate all bugs by changing the way the user interacts with the script notes: 1. currently there is a script called goLockloop that is triggered whenever the submit button at the bottom of the page is edited to a "yes". instead of having to wait for the user to submit the rep...
I have an Excel tracker file from which two dashboards and graphs are to be generated. The tracker gets updated regularly. The dashboards and graphs are to be updated automatically. Time line to complete task would be 2 days. More details will be shared with short listed freelancers.
Hello, i am looking for someone who can scrape the DHL parcel information with MS Excel vba. The tracking number is given (Column A) and the tracking information (Column C:L) should be scraped from DHL page (Link in Column B) This should regulary be done for up to 50 tracking ids.
Interacting with wordpress media library to get selected image jquery
I want to pull data in from [kirjaudu nähdäksesi URL:n] and other sites, and rearrange the data with auto-updating where it will store the data. I am looking to make graphs and charts. I am looking to have
Saludos cordiales, estoy trabajando en un proyecto de una hoja de excel para uso de pro-formador y base de datos, para una micro-empresa en el área textil, he avanzado algo con la programación y la obtención de costos en de los productos, y necesito ayuda para darle el acabado de presentación y que esta calcule algunos parámetros, necesario para el
I need a Macro which can extract specific data from a word file and then generate a User form with drop down having the data from the ...extract specific data from a word file and then generate a User form with drop down having the data from the word file and finally generate a word template with the values selected from the drop down in the user form
Hi , I need demo ro using userform in outlook use to set appoitment step 1 : build this simple demo userform in outlook step 2 : set appoitment based cretiria the vba code should look for appointments in the calendar in date 14.11.2018 in this exemple if from example there is appointment in this data from 10-13
I have two sets of data wich have DATE, TIME and four other values, some ...dates/times are mismatched, they exist in one side but not in the other and vice versa. I need a macro/script to align all DATES and TIMES and delete the mismatched values in sheets up to 250k lines efficiently. I have uploaded one examples of raw data that need to be aligned.
Crimson is a brand that deals in chic fashion accessories and has to come up with a website soon, therefore we need a content writer for the brand who can also make line sheets and catalogue.
Necesito un código en VBA que extraiga la data que está en la siguiente web: [kirjaudu nähdäksesi URL:n]:9d16c843bb5201b86696ba79f964adbf/stock/AAPL/financials y la coloque en una hoja llamada DATA. Adjunto el archivo excel donde debe realizarse el codigo. ---------------------------------------------
Tengo un hoja en Drive (Google Sheets) en la misma necesito que cada vez que me ingresa una venta en MercadoLibre se coloque en los datos del cliente que posee en en su cuenta: Nombre Apellido DNI Ciudad Provincia Ciudad Código Postal Teléfono El Código (SKU) de el o los productos que compro Cantidad de artículos Valor unitario Valor total de la compra
Hi, I have 7 spec sheets in English for a salmon company which I need translated into Italian ASAP - much of the information in them is the same so it should not take too long. They are technical, but easy to understand.
I hav...a client server business application which is basically an accounting, sales, purchasing and inventory control package. I need to create a Qlikview dashboard with multiple sheets. One to give overview of company performance, one for sales and customer performance, one for suppliers and their performance and finally one for product performance.
Google sheets script to send email and pdf attachment. The pdf name will be referenced on a google sheet. the drive is static. only email where cell C = N
I have two sets of data wich have DATE, TIME and four other values, some of those dates/times are mismatched, they exist in one side but not in the other. I need a m...values, some of those dates/times are mismatched, they exist in one side but not in the other. I need a macro/script to delete those values and align all other entrys in mutiple sheets.
Code to copy from a worksheet with multiple pivot tables, timeline slicers, and a pivot chart into a new workbook and retain formatting (freeze pane). We need to copy the date from the pivot chart to the a new workbook based on every filter in the pivot chart
please only German programmers Das Projekt muss mir VBA in Excel realisiert werden. Die genaue Beschreibung ist im Anhang zu finden. Es sind zusätzlich Dateien nötig, um die Aufgabe zu erledigen. Dies ist ebenfalls im Anhang enthalten. Die Programmierung soll in der Datei "[kirjaudu nähdäksesi URL:n]" erfolgen. In dieser sind bereits Module und Code zur...
I have two spreadsheets on the same google drive account. "Spreadsheet A" contains my shop orders, one order per row. Sometimes I will edit manually some of the cells for each order. I need a google apps script that automatically copies all the modifications on 4 columns of the "spreadsheet A" and apply the same modifications on "spreadsheet B". The "spreadshe...
Try to code in VBA but it's not working. Trying to select on range of 2 original columns and match a new column and replace it with one of the original columns.
Convert a Single Excel Macro VBA Calculator file with buttons and simple math formulas to an Android App to be used on Android Phones.
Hi I need the following formula. We use Google sheets for tracking projects. We need to be able to know when we have assigend a person too many tasks for them to complete in one day. So if we assign them too many hours, something goes red to highlight it. Here is a sample spreadsheet: [kirjaudu nähdäksesi URL:n]