i have a multiple vendors files in excel with huge date. i want to club all sheets into my own data sheet and and select my requirement in dashboard and report would generate as per my selection . Example ; Product 1 is there in three different vendor list and it should generate report with Product1 details of all vendor and highlight the lower
I have a Google Form that automatically submits tournament entrants to a Sheet. I want to create a Sports Tournament with about 10-12 different events where al...would also like to know if its possible to connect this to the website so that the results can be uploaded live to the site. Doesn't specifically have to be a Google Sheet, Excel is fine.
I need an excel spreadsheet that will track certain things in my business. I have 4 business locations I have many people that sell items at each location I need to track how many items were sold, by location, category, and salesperson I need a sheet that shows each breakdown with a chart I need a sheet per salesperson to input their sales per location
Need a Google sheets app script and macros which does the following. - Runs every 15 mins - Fetches the data from a website and populates the sheet with that data - And Applies conditional formatting on the newly added data.
I have a working file with excel for Drop down menus, I want to be able to use this file with google sheets, its seems google sheets does not work with dependant drop menus. So i need the attached file to be modified to work with google sheets.
...industry and having success there we're moving away from that product line due to the maturity and saturation of the market. We're now starting our new venture looking for the next big exciting product niches to sell that will be profitable for us as an arbitrage and private labelled product. Our website has just kicked off and we're now looking to expand
Support the Fashion Scientist on all aspects of product automation life cycle from concept to final development. RESPONSIBILITIES: Provide administrative support from concept to design to final development classification Master knowledge of all raw materials and trims Assist with the management of cross-functional communication between merchants
I have the scanned copies of 500-1000 survey sheets which contain 31 questions and its answers written with pen. Most of the questions are yes/no questions and the rest are like country, city, site id, date and time of survey, temperature, age, height, weight, blood pressure measurements(3 measurements with a total of 9 values), BP apparatus manufacturer
I have about 150 addresses in a google sheet. They are now in a single cell. I would like them changed so they follow the format: Name (Column A), Address 1 (Column B), Address 2 (Column C), City (Column D), State (Column E), Zip code (Column F). I will provide the link to google sheet for this work. Also, there are 10 addresses that I would like you to find the zip code for. I would like to sta...
Hi, We need to create a code within Google Sheets that will pull data from SKUVAULT API: 1. Products Report: [login to view URL] 2. Kits Report: [login to view URL] And will save each report to a specific sheet. 3. I want this to code to be scheduled to run every day. For more info about
I have the scanned copies of 1000-1333 survey sheets which contain 31 questions and its answers written with pen. Most of the questions are yes/no questions and the rest are like country, city, site id, date and time of survey, temperature, age, height, weight, blood pressure measurements(3 measurements with a total of 9 values), BP apparatus manufacturer
I need you to develop some software for me. I would like this software to be developed for Windows using SQL.
1) Windows 10 pro, Excel 2016 2) User should be able to identify target folder for process to run on all excel sheets in the folder as a batch. 3) Source data is Excel sheet (no more than 4 columns, and max. 100 rows) 4) Output is csv (12 columns, and no more than 100 rows) 5) Some columns in source will be split into many columns in output
I have the scanned copies of survey sheets which contain 31 questions and its answers written with pen. Most of the questions are yes/no questions and the rest are like country, city, site id, date and time of survey, temperature, age, height, weight, blood pressure measurements(3 measurements with a total of 9 values), BP apparatus manufacturer name
I have a list of 1000 products on a website, I need the following to be extracted from URLs I provide: 1) Serving size [g] 2) Calories [kcal] 3) Carbohydrates [g] 4) Protein [g] 5) Fat [g] 6) Saturated Fat [g] 7) Fiber [g] 8) Sodium [mg] Please only apply if you can finish this for less than $25 and in 2 days
Looking for an experienced virtual assistant to help us create a Google Sheet with our product and service information contained in it. Candidate should be experienced and proficient with spreadsheets, Microsoft Excel, and in particular Google Apps & Google Sheets. This will likely be an ongoing project as we will use the Sheet created to act as the
Looking for someone to enter approx. 220 0 k pdf pages and form fillings worksemailadresses from PDF to Excel. I attached an example of the pdf data. Please look at it before making a bid. Only the email address [login to view URL] 2 columns. If all goes well there will be lots of work like this in the near future
We have a Google Form that posts automatically to Google Sheets. There are 10 columns labeled "announcements" where twitter messages will land along with requested Date/Time to post to Twitter. We need a script to automate the process of: 1. Querying Google Sheets for new entries 2. When a new entry is found & we have marked a particular column
I need a house drafted in Revit 2018. I will need 6 sheets created with dimensions, basic annotations, and some schedules. This is a 2000 SF rancher with nothing too complicated to deal with. The main challenge is that we are working off of old paper plans that I have taken pictures of. As such I will need an extra set of revisions. That said,
I am looking to randomize the scheduling for my employees. I currently entire their requested time off via a google sheet. I am looking to create a script that will a...that will allow me to randomly assign them positions for the day based on who is present, and who recently had a day off. The script should be contained fully within google sheets.
...to write a complex formula that will look up barcodes and return the results accordingly. I am VERY experience in Google Sheets formula's myself, do not apply for this job if you don't have a complex understanding of Google Sheets Formulas. Watch the video of what I want: [login to view URL]
I have a spreadsheet that has needs to be sorted into multiple sheets. I don't think it's extremely complicated, but more than I can do. There are only 3 columns. I need to pull info from the first column - but not based on the entire col A info - not day, date - just the name of the city.
I'm looking for a freelancer who is expert with Google Sheets, Excel or SharePoint for automated extraction of data from websites. I'll provide a list of URL's for data extraction and the freelancer will need to design and create a product for scheduled automated extraction and filing. In summary, I'm creating a database to capture open source data
Need to hire someone who has rich...our wooCommerce platform. Accepted developer can do the following: 1. Install Wordpress on Siteground hosting 2. Install the flatsome theme 3. Set up automated product upload from excel sheets 4. Implement country filter to stop certain products being sold to customers in certain countries Need to start immediately
I have data of attendees/employees in a facility and I want to use this data to create two reports, one report to view the vacancies, the second will be used to calculate Payroll for the employees the reports must be dynamic, showing the last vacancies and Payroll data once updated by any team member I think we may need Google Script for the project but If you have a way to get the required re...
i have two sheets in excel,i want combine rows in one sheet if match with particular column value in excel
I have 2 google documents that contains a list of names that I need transferred into a Google Sheet. The documents contain names, file numbers, and a short description. They are not in a table, so I cannot just cut and paste the documents into the Google Sheet. The Google Sheet will be used to maintain a client contact list. There are around 5,000 entries to be transferred over. IT IS VERY IMPOR...
I create new project workbooks based on predefined templates from many existing workbooks...create new project workbooks based on predefined templates from many existing workbooks. What I would like is a new project workbook with drop down menus that lets me choose sheets from different workbooks and copies all selections to the new project workbook.
Hi everybody, This is task for someone with google app script knowledge + advanced google sheets knowledge I am trying to create a Stock Portfolio Spreadsheet that can automatically search my Gmail inbox for (specifically titled emails, that have specifically titled) CSV attachments, and then import them onto a secondary Sheet of the aforementioned
Hi, I'm looking for someone with experience in conditional formatting etc within Google Sheets. The project is to format the relevant cells in an existing Google Sheets spreadsheet to reflect the progress of: - The total project - Each phase of the project - The completion of each task The end result to be a Gantt style chart to help us with our
Super easy project. For the 2 sheets labeled "Purchase Letter -Peo" and "Purchase Letter - QC", create a macro on each sheet that prints all the groups individually. Cell A2 needs to change each time. The value in A2 goes: 1, print, 2, print, 3, print....and on until the end of the list. Please ask questions before bidding. Again, this should
Some Stats needs to be udpated in spreadsheet with little research over Google results.
I'm working on arcgis database designing, I prepared the database model in excel sheets I need a tool or script to convert the model into geodatabase without me having to create the feature classes and the attributes one by one
Need VBA code that will search for individual cells of from one sheet to and find the match in a different sheet and copy and paste what you find a separate sheet
Addon required for a Google sheet for saving sms received on a number from a specified number only. Addon should ask for both the numbers when applied to a sheet. The receiving number would be in a phone permanently and receive sms.
...html and uses Google Sheets as the data source. The data table should be editable as inline and through the "New", "Edit" and "Delete" should be in real time so anytime the data is changed in the table it should be updated in real time in G Sheet. Make sure to use Bootstrap 4 as CSS framework and the latest versions of both G Sheets API and jQuery.