I have Excel sheet which has 3 colons. Country name. User name. And password. Inside that file 64 usernames . I want to put each username and password in single Excel file and each file to be saved in country name. So I need 64 files each file only include the username and password of that country. Thanks This job was posted from a mobile device,
...transferred to a Google Sheets with only certain information transcribed. (See "example sheet" to show what information from one slip transcribed.) Very quick and easy (in doing this myself, I did 60-75 seconds per slip so maybe 20 to 30 min if you're slow), will share access to Google Drive folder temporarily to fill in Sheets. Most likely I will only
I want to load new data from existing API endpoint (oAuth2) to Google Sheet (new row) or even better in Google Cloud BigQuery
we deploy volunteer teams to complete environmental and humanitarian projects, teams complete an online form, we then create a confirmation/invoice, we then collect payment, we then deploy teams to projects
I'm looking to work with someone who can build automation into a spreadsheet, so that I can take data and reformat it automatically, using automation, macros, etc. The data is a list of property owners and the addresses of the properties they own. i need to 1. migrate from raw data into clean data template. If you reference the clean-transition
I need an individual filtered report by agent with the following need a count of each agent transaction and with the total of BF and Premium(Not together).
Hello, I have developed a SCADA application in Indusoft Web Studio ([pro zobrazení URL se přihlaste]) and I would like to integrate a real-time WPF chart into this project. Indusoft allows for the integration of .Net 3.5, ActiveX and HTML objects. The charts I would like to use are from [pro zobrazení URL se přihlaste] Let me know your thoughts. Thanks!
I have 10 excel workbooks with indentical excel sheets (same structure). I want a query (in power BI - DAX) to retrieve the information in these sheets in a single data sheet.
...to serve as a reporting/tracking/trending experience for ~25 Google Sheets (based on location and edited by groups) containing QA information. At this time, only data from location-filled QA spreadsheets will be used, but the dashboard Sheet will need to be easily converted to Excel for an upcoming migration to SharePoint in May. That conversion is out
Goal: #1: Using "Report" Sheet when a user types in the Start Date and End Date of data they need, the query will search the "Returns" sheet and display all the rows that fall between those two dates. #2: On "Report" Sheet in Cell B5, total Column G (Price) *Returns sheet will have an infinite amount of rows
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 are my
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 Column
...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
...that they are first name last name, not initials, or middle names, etc. Please let me know if you can do this in google sheets/excel, and i can send you a sample to try out. I've attached a sample of the data, on the raw tab, and the headers in the clean tab. Please also respond with how you would do this in excel google sheets/briefly. Ple...
...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
...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
I need a macro which will allow me to compare two excel sheets containing revenue info (current month and previous month) to automatically generate a report of the month on month differences
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' Anythin...
I have google sheets work book with data in 3 different sheets. I need to combine these into one everyone or at certain times.
...[pro zobrazení URL se přihlaste]) 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 [pro zobrazení URL se přihlaste] Need a plugin that can...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. [pro zobrazení URL se přihlaste]
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.
...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 as "-" and later for same
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: [pro zobrazení URL se přihlaste]://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 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...
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: [pro zobrazení URL se přihlaste] [pro zobrazení URL se přihlaste] 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
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 [pro zobrazení URL se přihlaste] 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 form...
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 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...