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 excel files with a lot of macros and formulas and different things and I can't figure out how to merge them into one file. One file has like 20+ sheets and the other file just has one sheet and I want to have them all in one file (you can move the 20+ sheets to the 1 sheet file, or move the 1 sheet to the 20+ sheet file, or vice versa).
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".
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: [login to view URL]
...need to build a database in Excel of all of these records, which requires copy/paste from the website in to excel. I have timed myself doing this, and without the help of any macros, I am able to complete one client record per minute and I have a total of 615 client records to enter. This should take around 10 hours to complete. In addition each client
We are using Ch...server via HTPP POST. 7) Repeat from point 3 until the next day, then repeat from point 1. The scripts also can be run manually, for testing. If possible, the new scripts, or macros, or whatever, should run in a standard Windows machine. And have to be editable, inform about what is happening, and have a verbose mode for debugging.
I have an excel spreadsheet with some VB code macros that prompt the user for data input via popup screens, and output some data in a pdf format that I was looking at getting translated into google sheets. This macros that is being used to track a few different things for projects, and was interested in seeing what sort of ballpark timeframe and cost
...ensure we hit our quality controls. If you can say yes to the following, then perhaps you can join our merry band! 1. Advanced level of excel ability and familiarity of using macros, v-lookups and templates. This means that you are excellent with excel ! 2. Expert data validation skills and meticulous attention to detail. Ability to find the unusual or
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.
...I will require screenshots of forms filled initially until trust is built. It's a simple task, and one which could be automated/streamlined to a large degree if you use macros or keyboard shortcut software to paste the email content. (there are some small edits to personalise the emails for each business) (I use short keys lite (free) to insert
I have some work, in an Excel spreadsheet. Looking for a macros to combine multiple csv files and filter based on set of keywords and remove duplicates based on one column.
I have some work, in an Excel spreadsheet. Looking to combine multiple CSV files and filter based on keywords and remove duplicates based on a column. there are two similar csv file formats with one having extra column
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...
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 ...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.
...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 pretty basic, but my hope is to then be able to transfer some of the more detailed
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
I’m 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!
in the Financial model as enclosed,I am not able to write a macro in this particular file, it says Compile Error. Syntax error. However I can write macros in a different excel file..not sure what is the problem in this file... Can you please help?? [removed by freelancer.com admin] Thanks
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.
...of any discrepancies. The data covers up to 2.5 years history for some employees. *This project is half completed, the remaining work on the project requires additional macros, conditional formatting and some automated calculations* If you're interested to discuss further, i'll send a copy of the file and we can talk about the requirements in more
Looking at creating and automated excel file with VBA and macros for a certain task which would ultimately be automated, save to PDF and .Doc and also enter into another database which will be automatically formed. More details to follow
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.
I need develop an google sheet that imports and shows time attendance data from an fingerprint device ( from brand zkteko )
I have an application that automatically renames movie files and moves them to the correct folder. I need this application to run automaticall...the background whenever there is a change to a specific folder. There are a couple of buttons that need to be clicked automatically as well. I believe I could use a script or macros that can handle this task.
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.
NOTE: Must have experience with coding macros in the Excel PERSONAL file. If you don't know what this means then please do not bid. I have an existing Macro. The function of the macro is to read a sales data file and insert the sales quantities into cells of MASTER file. Task: Extract an Order Number from the data file, and paste into into Row
Have many multiple excel files. Need macros that will take each main file and split into 100 items per file and save the file as csv Each file should have header labeled SKU and then underneath it should have 100 sku's. Each file should be saved as CSV. It should only take the items in the first column... Should be done in 24 hrs...
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 Period...