Name sheets excel using vbscriptJobs
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 [log ind for at se URL] data is au...
We want a freelancer who are expert in excel and work in Advanced Excel Formulas.
...[log ind for at se URL] 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
...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 want to pull data in from [log ind for at se URL] 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
Hello, I need to connect my Octoparse API with Google sheets API. I would like to create the automatized system and learn how to do it for future purposes.
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.
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
...the following: 1: It needs to be built as a .DLL instead of a .exe and be able to be called by a VBScript 2: Needs to accept 3 input from the VBScript (currently those 3 values are hardcoded in the C#) 3: Needs to output 1 value back to the calling VBScript. 4: I have sample inputs and expected output so should be easy to verify. 5: Source code needs
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...
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: [log ind for at se URL]
I need someone who can create excel sheets from information they get from amazon. This is data entry work and is pretty simple but time consuming. We will provide training. Need hard worker.
We need to enhance our current Excel sheets to export information into accounting software, ComputerEase. This project is for a small construction company suing budget/estimating sheets, time/materials sheets, ect.
1. Retrieve data from Google Sheet. 2. Retrieve a PDF file from Google drive, in a specified location that is in the sheets cell as “PDF1” save this to a desktop location. 3. Write a text file that contains, this google sheet data + file location of the down...
I need certain formulas made to highlight key points of Data. I have attached 2 example images so you can have more of a visual explanation of what I need done. I will have further work needed, however they will require some more advanced skills, so any proof of past work will be appreciated. If you cannot show me past work that is relevant to what I need, then I will require you to do a quick te...
Hello, I have a task I need help with... I need you to go into this app called "PepTalks" and in the beginning before signing up the app will prompt you with a screen with quotes. I need you to write down all the quotes (or 100 at least) into a google sheet document. Grammar must be impeccable. All punctuation marks must be present, including quotation marks.
Hello, I have a task I need help with... I need you to go into this app called "PepTalks" and in the beginning before signing up the app will prompt you with a screen with quotes. I need you to write down all the quotes (or 100 at least) into a google sheet document. Grammar must be impeccable. All punctuation marks must be present, including quotation marks.
...into Excel and then updating a variety of worksheets/charts from there. Basically, I want someone to help me stay on top of downloading all of this data and keeping the sheets well maintained. In addition, I am always happy to hear on any improvements to what I do! Finally, this is a starting step for me in using Freelancer - the initial sheets are
All requirements are to be built in Google Sheets 1) (Tab 1) Extract global top 500,000 followed streamers. The top is based on the highest following. 2) (Tab 2) Extract European top 500,000 followed streamers. The top is based on the highest following. 3) (Tab 3) Extract UK top 500,000 followed streamers. The top is based on the highest following
...looking for a developer to pull slack user data from the Slack API into a google sheet. It would be google script code that users the slack user api that will fetch info such as name, email, time zone, if they are active and then have it populate a google sheet. This is done with a couple slack Rest API calls! ...
I just need a simple Google Sheets script to copy the entire last row and paste it down one row below. This script will be run once a day to keep copying down the last row for each new date. I can get this scrip to work in Excel but not Google Sheets:
I want to store some data to one of my google sheets in google drive. As these codes will be deployed in my google cloud VM, no web authentication is allowed. Please use python 2.7 to finish this job. Easy job and good payment.
I have a spreadsheet in excel with a set of macros and buttons written in VBA that i want to convert to google spreadsheets, where macros should be written in Javascript. The file is attached.
I need a tool which should have following features. - filters the emails received on Gmail. - Parse required text only from each email. - Paste the text into the google sheets into the related cells. - An example can be provided on request.
Looking for someone with experience in finale makemusic to write musical sheets
I need develop an google sheet that imports and shows time attendance data from an fingerprint device ( from brand zkteko )
We have a google sheet used for a business. It has multiple formulas and scripts that automate most of the business processes. We need someone to make some changes and improvements on it as the original creator is not available.
We are keen to find basic level data entry candidate to copy email domains from a Google Sheet into our order management software, Linnworks. Ideally, this should be done within a two week period as there are around 18000 to input.
...addresses will be listed in excel spreadsheet line by line one per row.......so the program will need to open a new blank email....read text from either a cell in excel sheet or a text file(your choice) for the body of message...attach a specific file(this is usually a pdf of some sort so can make a name we need to name the file standard and location
Fill in 1 column in an excel sheets from a website. links for each entry is provided in the sheets. The column will just contain phone numbers with total number of 3115 entry. Sample is attached
I need to Vlookup data from different google sheets.
Hello - I have a simple contest for Excel Masters for a spreadsheet: Period Flow thru Worksheet: Criteria 1: Column I “Actual”: Match (sumifs) column C with “Sales Tab” column b “restaurant_id” Criteria 2: sales tab “business date” (column C) with calendar tab “date” (column A) Criteria 3: Period Flow Thru Worksheet row 3...
I need you to develop some software for me. I would like this software to be developed for Windows using .NET.
Application has a w...You must provide links to external libraries that you may have used to complete this project. Such libraries must be open source or provided by Google for integrating with Sheets and Drive. You must use your own API developer keys to develop and test this. We will replace those keys with ours when we test and accept your code.
Looking for someone to write complex excel sheets, VBA writing, web site etc, this would be an ongoing role in a growing company.
Looking for someone to help me create a bot for my Discord server. I manage a gaming guild that needs to be able to manage weekly activity and rostor placements. Using Google sheets, I want my members in Discord to be able to @mention a command, and then show the results of a specific group of cells in a google sheet.
There are 2 excel sheets, we need to apply filter on 1 column of first sheet and then compare these values with another. If there's match then need to mark as Y in other column. We need to do this with the help of 2 excels, among which 1 is common and 2nd will be new for comparison (having filtered column). We need to do this using java or python technology
I need someone to help me repair this COUNTIF formula =IF(COUNTIF($E$1:$E$13300,E1)=1,"Unique",COUNTIF($E$1:$E$13300,E1)) Here also is a video which shows the difficulty that I am experiencing. [log ind for at se URL] Assistance is greatly appreciated. I will pay $4 for full completion of this task. The solution must work in my existing sheet.
Using the GTMetrix API I'd like to pull data from GTMetrix to Google Sheets. I'll need the PageSpeed and YSlow scores as well as Page Size, Number of Requests, TTFB, First Paint, and Fully Loaded time. All GT Metrix reports to be run from London using Chrome.
Looking for someone who can develop a website which will be linked to google sheets. The frontend of the website will be identical to a website which I will provide you a link to, the backend will also be the same, which I will provide you access to as well. The website has few bugs which will need to fixed, so you will need to be able to not only mirror
This...authentication is incorporated) for Google Sheets. This piece of code will be written in Javascript/Nodejs. Essentially, I need a technical plan on how you would append a Google sheet's column with values from an array containing a series of strings. Info about the API can be found here: [log ind for at se URL]
I need an Excel spreadsheet converted into a Google Sheet
...available from here [log ind for at se URL] This parser seems to have the functionality i require. I am able to retrieve single values from the JSON string using this parser, using [log ind for at se URL] "MS_Milestone_Folder:" & [log ind for at se URL]("fields").Item("customfield_18856") or for an array [log ind for at se URL] "MS_M...
Sell Sheets - I need a series of 7 sell sheets developed that will be used to introduce a new line of products. - There will be one base design that will then be customized to a variety of themes (sports, religion, holiday, pets, etc.) - I need someone with the following attributes: o Specific expertise developing sell sheets that you can demonstrate
