This is NOT a data entry job. Please don't message me unless you know how to do advanced google sheets data manipulation. I have a set of "raw" data. I want to clean it up and format it into a new tab in google sheets, using macros, scripts, automation. the raw data has a list of owners and the real estate properties they own. these...
make a script which replaces the text of one cell with "_____" whenever that text matches the text of a cell. for example cell G: Paul, don't be late. The movie starts at seven o'clock. cell I: o’clock I want cell J which has this script to write: Paul, don't be late. The movie starts at seven _____.
I have a Google Sheets file that I need a formula for. Please see the attached images. I need a formula that will copy the data on the sheet labelled "All Ongoing Cases" and put it on the correct sheet depending on the value in Column "I" For example you can see that the data in Rows 3&6 has been copied to the "DIP ACCEPT" sheet because in ...
...Google Sheets doc with four columns (Source, Date, Description, Amount). I also have two .CSV text files (one of checking and one of saving account data). I also need these two documents parsed and loaded into the same Google Sheets doc. This should be more straightforward. I have the PDFs and .CSVs along with an example of a Google Sheets doc how
I want to make database which extract automatically report from those 5 work sheets the result will be like that guide name , the flight which he will collect driver name and his number the hotel names + hotel guide which work in this hotel + hotel guide number + meeting time in each hotel + Pickup time from hotel the tourists names in that hotel
I will provide a list of “raw” data that contains the a list of real estate properties and their owners. I want to be able to mail these owners, but only one letter per owner. At a high level the owners are people and businesses. I will use one type of mail letter template for the people owners and a different type of mail letter template for
...take the sheets that I have created in Microsoft Excel, switch them to Google Sheet documents (layout must be the same and fit on one page), and merge them with the macro to make each page work as needed. Then adjust the macro to suit each document (the reference cells are different on each). Person to hire will need knowledge in Excel, Google Sheets
...scope and its functioning to be joined to me for the creation of the site. - Data Entry to insert products on my eCommerce site of the products to be imported from abroad and saved as draft. I will write only to those who answer me writing the result of the following sum: fifty two plus eighteen (in numbers). The freelancer must be Italian mother tongue
...formulas but does not seem to be working as planned. The ideal candidate for this position should have extensive experience and knowledge with formulas and scripts within google sheets. I will provide google sheet template that I have been working on as a starting point in the right direction. Thank you for taking the time and showing an interest in this
I have ongoing work related to our previous project 'combine data in 3 different google sheets into one on fixed time basis'
Hello, I need someone to fill out product sheets of computer components. There is the reference of the products, it is necessary to copy the reference and to stick it on Internet, to recover the information and to write them in an Excel file, the excel file is pre-filled. There are already the files as well as excel files, 80% of the products can be found
...on the Google Docs (specifically Google Sheets) platform to advise me on two things: 1. Is it possible to create a script to allow for the same comments to appear on different sheets so that we don't have to look through different sheets to find the comment we are looking for? We work on multiple Google Sheets where we use comments to give instructions
Hello, I need to create a query that will update a column's values based on data from another column. Here is the plan: There is a table called 'user_points'. It contains a user's ID and a list of points transactions for that user, plus the date that the transaction happened. Some transactions add points and some transactions minus points. E.g.
On Sheet1 a have a table and on Sheet2 I need to have sorted table same as on Sheet 1 but with SUMED values (rounded up in images) but without duplicate rows. I have an example in attachment ( the way it is and the way I want it to be ).
I need to match data from one spreadsheet with data on another spreadsheet. See attached images as example. I need this as soon as possible please. I would also like the formulas intact so i can edit as required.
We currently have a product list we have created in Google Sheets we then have product photos in Google drive we need to clean the data to upload to an e-commerce website, most of the files already have correct image names and formating in Drive however some are missing or duplicates, we need to identify what images are missing and what images need
...ticket template sheet created. One sheet/tab in one workbook. I dont want to have to copy and paste a new sheet/tab everyday I go into Excel to do up a work ticket. So, I am looking to have Excel auto-create sheets in a sequential number series (our purpose is ticket numbers) made from the layout of our template Meaning, each sheet tab will have a new
I need this formula within 24 hours of awarding the project and it had to be compatible with Google Sheets. Using Google Sheets, I need a formula to work out the following: In one cell, if the number entered by the user is 240 or below, I need the formula to state that as 'Low Risk' Anything between 241>600 would be categorised as 'Medium Risk' Anything
I have google sheets work book with data in 3 different sheets. I need to combine these into one everyone or at certain times.
I have a large sheet, that I need to sum totals. Only way I currently know how to do it will be to many =sum(A#:C#)+(A##:C##)+(A###:C###) etc, but like a thousand times. I have basic "SUMIF" knowledge, but I don't really know how to carry it forward since I've updated my sheet.
...[fazer login para ver a URL]) that I need to be converted into a file type, preferably MS Excel or Google Sheets (whichever is your specialism). The actual form, used to capture Project Requirements, will have up to 100 fields. A rudimentary (unprocessed) Excel file will be available on project initiation. The final version will need a layout/worksheet
Expert who can create a wordpress plugin. Required function: check this video [fazer login para ver a URL] Need...Develop wordpress plugin that can insert the title and content into one accordion for each row. here is google sheet api can maybe used for pulling the data. [fazer login para ver a URL]
Hello, Please include the word WABO into your bid to be considered. I want to combine these excel sheets Certificates and TWIA Info. Pearland Contacts is the primary file I would like to add too. I would like to add the TWIA certificate Pearland to the excel file starting with column N. The way you are going to match the correct lines is from the address
We need to integrate orders data from shopify with google sheets. Whenever new order is received it should add a new row in google sheet for that order with all required values for the order.
I have data in sheet such as - date, time, symbol, buy/sell, qty, price, etc. i want google app script codes to find first transaction of any day for particular symbol( buy or sell) and give it name and name and later for same symbol on same date - it should add/reduce qty from first transation qty eg. first transaction is sell - it should display qty
...auction website backwards. Here are some requirements that the platform must have: - users can register as "customers" or "sellers". - customers who publish the ad must deposit a sum of money in Escrew mode. - all users purchase subscriptions and receive in exchange for credits to be used as an exchange rate in the platform. - customers can post announcements
Hi there I would like to have a website build that is mobile friendly, secure, and that let's my customers order a few of my products online (10-15 products tops), they should be able to choose from standard sizes and custome size, choose thickness, finish, and quantity - they will pay with paypal. 4 Page Website : - Intro - Products - Order - Contact If you think you can help, and get ...
Here is an example for what i want: https://docs.g...what i want: https://docs.google.com/spreadsheets/d/14opGimrlYh_Jfx3I8CDDawatZL7MSrxSNsskQ0mmNDk/edit#gid=0 Get data from INPUT and using formulas or script, it need to result the data from OUTPUT. I need it in Google Spreadsheets, not EXCEL. If you have any questions, please feel free to ask me.
I need a ...multiple choice answers, a several sliders that record a number from 1-20. Once a user clicks a SUBMIT button, they receive a one-page summary of their results, including the sum of all the numerical scores they entered. See attached file for exact questions and format requited in the web page, and sample output that needs to be generated.
I have two separate excel sheets that I need data summed up. There is a quantity column and a Vendor Part number column. These represent each individual sale of a Vendor Part #. I need the quantity column totaled by Part #. For example the spreadsheet Special Order Sales has the following items: 1 BMP3422068C 1 BMP3422068C 2 BMP3422068C 1 BMP3422068C
I invest in the state of Arkansas and I need a google spreadsheet to keep upcoming auctions organized. I would like someone to put together a spreadsheet of all the counties in Arkansas that have an auction date from 2017 only. Ive added an image of how I want the columns to be organized I would specifically need: -- each county to have their own sheet (tab). *75 counties total *count...
...my database would generate on a daily basis. For those familiar with basketball it would take a look at the value in the hc column of the team in the database and then would sum up a number of stats that the team has accumulated in certain scenarios. You can have a look at the sql file to get an idea what the process does as I have included that the
I am looking for someone to create two way sync between sheet on Google and SQL Server. It can be a .NET console app or Windows Service (Preffered). Please suggest time and cost.
We are a 3PL for ...making invoicing easier. We do have a variety of charges (shipping carrier, pick & pack, packaging costs, etc). Relevant links for reference: [fazer login para ver a URL] [fazer login para ver a URL] If you believe you're up to the task please reach out! :)
I would like 15 information sheets made of the following things: Trees: Beech tree, hazel tree, holly, Hawthorn, oak Birds: Robin, Parkeets, sparrows, black birds, red kites Insects: Woodlice, worms, beetles, ants, grasshoppers These are to be used with children so the front page needs to be nice and simple and the back page can have a few more
...case of any errors made by past developer in relation to automatic print out. You are required to fix it at free of charge. 4.) Upon completion of project, 5% of total project sum will be withhold as guarantee bond for 3 months. After 3 months, the 5% will be released to you. Notwithstanding with this clause, if we discover any apparent mistake done by
As discussed composite log cropping 1.15 usd per well all logs in reports saved as a properly named image file only the composite log is ...npd logs where available use peter provided tiffs where no npd logs or npd logs are of poor quality price currently set to 1500 usd additional milestones will be created once sum has been overcome donotwork create
As discussed composite log cropping 1.15 usd per well all logs in reports saved as a properly named image file only the composite log is cropped in head...npd logs where available use peter provided tiffs where no npd logs or npd logs are of poor quality price currently set to 1500 usd additional milestones will be created once sum has been overcome
Require a costume google sheets template to be create inline with my excel formatted spreadsheet I have an excel sheet template that I want made exactly into a googlesheet template You will be able to see a number of features it has when I share the doc such as: - Like calendar pop up on the dates - Box appearing when the dates are changed etc -
I work in logistics and we need a new truck for moving around trailers from yard to yard . Our current truck is not right for the work and another one...and a new truck to proposal getting the new truck Simple project of introduction, problem, solution, justification, cost comparison , conclusion. I have all of the research Excel charts would be great
I ...customer's personal information. However, you should be able to create a trial account at [fazer login para ver a URL] to get to the backup file. if I try and import the file in Excel or sheets it won't open. Their customer support mentioned needed SQL server but weren't very helpful other than that. I need a way to export this file into a readable format.
I have a current project that...current project that would need to be updated in Solidworks 2018. I've attached the 3d model, sheets, and a PDF with revisions noted. I would just need the revisions changed in the 3d model and updated in the sheets. Final deliverables would be a PDF of the sheets and a Pack and Go of the Solidworks sheet file (.SLDDRW)
Hi, please do not "Sir I can do this" or similar without reffering to the job description and just giving a sum - as I will not read it. Please write something - yes I have experience with Mendeley and I can send you a CSL-style according to your specifications. The specification for the style-sheet (which are somewhat like Harvard style) are as follows:
Hi there, thank you for taking the time to read our contest ! We are looking for a template for one page (recto verso) where we can inject text about our products. This template must be finalised in Word format so we can open it up every-time to inject the text of each product and produce a pdf file. -> This is for a business so it needs to be attractive to look at, but no "over-engineerd...