I am trying to do two tasks on a Google Sheet I have. The tasks I would like done are to link 1 Sheet, called Order Summary which needs to be sorted by customer names. There is 1 sheet called Customers with 4 columns. As these columns are updated, I want the sheet Order Summary to update. I also would like 1 script added to sheet Order Summary that add 1 blank row between each customers orders ...
...organisation and we need 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
We would like a Macro to run inside of Coral Draw that will place the same PNG file onto a template that we will provide. The template will be of a Shirt and there will be different variations of that shirts colors. (Black, Navy and so on) It will need to allow us to batch the Images from on folder and then save the grouped image into either PNG
I have an excel spreadsheet that pulls 2 worksheets, parses and combines data, and creates a report for each customer. Lately the spreadsheet stopped working and is throwing a type mismatch error 13 on one of the routines. I do not know what changed but I need to get it fixed. I'm also open to just having the whole spreadsheet re-done or at least cleaned
I am looking for developer who can check and fix one of script. One of url opens 9500 db queries and i need help. We are using GIT and MariaDB/MySql Task for today/tomorrow.
I'm a poker player and have around 100 ranges that I would like across bet sizing grids vs positions. There is a video attached that shows the idea exactly. The grid size on each sheet will vary, but each cell of the grids will link to pictures of ranges across the grids bet sizes. At the bottom of the excel video you'll see there are 6 sheets with the same macros on each. All the inform...
hi , Simple task for serbian, macedonian speaking freelancers. There are about 9000 short articles that need to be check against pdf document. Post images needs to be atached and uploaded as per document and some text updates. thanks for bidding
...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 balance 5. Get position for any individual cryptocurrency
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
The requirement is to create a macro on an excel data set. The macro should be able to do the following tasks: 1. Should do minor data corrections with the click of a button 2. Identify the trending of data 3. Generate graphs based on certain logic These are high level requirements. Details will be shared once confirmation received.
So its a simple project for an experienced person. I don't need someone that has not done this before. this should be a simple 5 mins project. I have a VPS that is running ubuntu and apache that already has a domain attached. i need another subdomain to run in it as well on a folder called profile.
Need a developer to make an excel macro. The excel macro when run should do the following: 1. Download closing prices of a family of stocks (NSE/BSE India) from the internet 2. Update them in excel automatically 3. For each stock, perform exponential regression, calculate ATR, 100 day EMA, and if there is more than a 15% gap in prices in the past
I have an old workbook - xlsx format - that I forgot the password and need to unlock. Since its newer than Excel 2007 its encrypted and the old style VBA password buster wont work. To confirm you have unlocked the workbook show me "Period 1" sheet
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 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.
Thé job is To review video monitoring (1 camera) To complete a table with entry and out times of people (5 people) This job is To be done each week This job was posted from a mobile device, so please pardon any typos or any missing details.
...market data, but a while back, Yahoo Finance cut off it's free download API and I am not able to get the stock market data. I just need someone to program the macro to: 1. Download the data for the symbol that I put in up to the maximum years back per the data vendor 2. Put the weekly data into the spreadsheet. 3. Integrate the weekly data...
I want to build a client check in app for the iOS. The app should allow you to log in as an office. Then on the iPad you would have a screen that would stay up that would allow them to check in and select a reason why they are visiting the office. It would show a list on the same screen of the order of customers and how long they have been waiting
Hi there, I am looking for a native US english speaker, academic educated, to verify a press release of in total 1018 words. The verification should be done with "track changes" set to on. It's a rush job - needs to be done today. Looking forward to your bids, cheers, Joost
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
Hi, need only freelancer with outlook appointement experience! pls see instruction file . need sub which get date and duration and set the appoitment...need only freelancer with outlook appointement experience! pls see instruction file . need sub which get date and duration and set the appoitment as when you execute the macro need it today Thanks
Hi , I need demo ro using u...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 the new appointment will be from time 13-17
...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
...have an excel out put from an app which i want to paste it into excel on one sheet and then have another sheet on the master file which pulls key data from the pasted file and then i want to click on a macro button to copy the new manipulated sheet and create a new sheet without the manipulator in it. i also want the new excel file to retain its ability
We have some sales data in a flat file that is structured like this at a transactional level: Product Date Quantity ABC 1-Nov-2018 24 ABC 5-Nov-2018 36 XYZ 12-Aug-2018 32 etc We want a macro VBA Program that can take this data and do the following: 1. Summarise to monthly level by product Store as a new
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. ---------------------------------------------