I have a spreadsheet in excel that includes a macro simple (less than 50 lines of code) It mainly just moves stuff around I have recreated the spreadsheet in google sheets [login to view URL] but I can’t recreate the macro as I don’t know google apps script. Is this
...people for multiple Skills. We need people for long term projects. We have projects related to different skills sets. 1. Data Entry, Data processing, Excel Macros, Excel VBA. 2. Typing 3. Word. 4. Excel So Please welcome all freelancers and Bid on the project. We will review the profile starting monday and provide the projects related to skills.
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
Hello Salion. We create Excel templates and custom spreadsheet solutions for global markets and are looking for a teammate who is extremely skilled in Excel and VBA. If you are interested joining us, I would like to discuss opportunities with you. We may work on some ad-hoc tasks or more complex projects depending on the situation.
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
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..
I have several sheets in a Smartsheet account where I pull that data out (via an ODBC connector), transform it in Alteryx, and that output is then used by Tableau for a dashboard. Right now, the data between Alteryx and Smartsheet is manual. I want to be able to automate the "run workflow" button in Alteryx (a hotkey of Control+R) which will update
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.
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 word file and finally generate a word template with the values selected from the drop down in the user form
...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 then
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 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.
Necesito un código en VBA que extraiga la data que está en la siguiente web: [login to view URL]:9d16c843bb5201b86696ba79f964adbf/stock/AAPL/financials y la coloque en una hoja llamada DATA. Adjunto el archivo excel donde debe realizarse el codigo. ---------------------------------------------
...MYSQL and to create an ODBC Connection from a different computer to the MYSQL Server. This connection must allow us to link MS Access with MYSQL database from the server. This work may imply to set up our router. All of the accessing username, IP, Passwords will be provided. We must receive all the instruction how to create ODBC Connections. In other
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 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
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.
I need a QT specialist, that can write a custom database driver plugin for me. I have some troubles with the existing QODBC driver plugin. First I would like to add some debug messages to the existing QODBC driver plugin to understand, what it's going on. When we know, where the problems are, you have to change the existing QODBC driver plugin to a custom one.
I have an Excel spreadsheet that uses the worksheet_calculate function within VBA to monitor changes to a cell on Sheet1, which in turn triggers a timer whenever a change is made to that cell; worksheet_calculate is used instead of worksheet_calculate because the cell contains a lookup formula that references a table on another sheet within the workbook
Manufacturing business wants to take a daily download excel file from GE Appliance website and create a Macro/VBA tool for non-excel users. The tool would look up our internal part number and box count from a table and output a pick sheet for shipping with customer part number, our part number and number of boxes. Should be able to select time range
I have a very complex macro which takes a csv of all our orders and put it in a neat printable html format. It isnt doing one of the things its supposed to properly so I need that fixing and I also need to give it some extra functionality.
- Updating of pivot tables to ensure that numbers change when cells are updated - Advanced filtering - Having a data entry sheet and using VBA to transfer the new data to the bottom of the existing data set - Improve user experience by making future data entry convenient
Hi dotnetsqlCoder, I noticed your profile and was wondering if you knew anything about SDMX (Bank of Italy uses it along w...along with most of the world's statistics agencies - effectively API). Essentially I was wondering about two options 1) Connecting my database (mysql) to SDMX or 2) Creating an ODBC script which connects SDMX to my website? Dan
Hi Mehdi A., I noticed your profile and was wondering if you knew anything about SDMX (Bank of Italy uses it along with mo...along with most of the world's statistics agencies - effectively API). Essentially I was wondering about two options 1) Connecting my database (mysql) to SDMX or 2) Creating an ODBC script which connects SDMX to my website? Dan
...steps development a downloadable excel calculator. The interface and calculations are confirmed and tested. To improve the usability of the tool, we will need the excel spreadsheet to host a number of specific VBA's to improve usability and functionality. I need a VBA programmer for approximately one week with proven VBA credentials to further assist
We are looking for Freelancers that can help us in building a solution where we can upload/downlaod information from an MS Access database to WooCommerce and back using the WooCommerce API. [login to view URL] We would need an expert in communicating with the Woocommerce API and Parsing XML data. The goal is 1. Automate and import/export of products from Woocommerce which would also include imag...
Need VBA code to select a row in external SysListView32 and send right click to it using sendmessage or postmessage API. Assume hwnd of SysListView32 is known.
...on Xamerian Forms. I've attached a word document along with the project that you will start with. When I accept someone as programmer for this project I will send along the ODBC connection string to connect to the database in question. This whole project will probably take an experienced programmer a few hours (if that). This is not overly complex
Hi my name is Sotiris Kazabakas, I need an excel with some pop-up alerts and sound alerts. You will find more on the word that i have uploaded which includes a description of what i need the excel file to do. For any questions do not hesitate to ask.