Need Google Sheet customization. Please address this project only if you have good experience with this tool. We will need assistance with it and extra features on demand for a long period of time. Need quick TAT and immediate availability.
[login to view URL] I need the FB Dashboard of this website but in Google Sheets
...subcategory_id The script should create the query for me, so that it would be easy to run different queries. The parameters that I would like to be able to enter into the google sheet to create the query would be: q sort_by [login to view URL] [login to view URL] categories subcategories price start_date.range_start start_date.range_end [login to view URL]
...format for visualisation purpose. Knowledge of Venn Diagram(you should be able to create a Venn Diagram using data from Excel dynamically), Set Theory (Union & Intersection), Macros etc is a must. You should be able to create multiple PDF reports(similar report for multiple entities in the excel) from the Excel data in a certain visualisation format
The Input File contains one single sheet with Multi-Level BOM - i.e. Multiple BOMs linked to each other. The output File is One file with Multiple sheets - each containing one single unlinked BOM.
1. Product URLs are in A column 2. product descriptions are in B column, write a script to get the product description row by row (if the cell in B column is not empty, then skip it. For example, cell B3 is not empty, then skip row 3) 3. product description is the "Inner HTML" of the HTML element <div id="product_detail" class="product_detail"> of the product pa...
I am launching an online e-store for selling sports equipment from various vendors - basketball goals and backboards, lockers, baseball equipment, tennis, track and field, etc. These are stock products that I am selling primarily to commercial (private sports training facilities & arenas) and educational institutions (schools, universities). I need to upload product information from my manufa...
I need help creating a graph with three lines, each a very different scale. These graphs are created off of excel templates that I use to run hundreds of widely different files with widely different scales. I also need help modifying a sort macro.
...choose a freelancer in about 1 hour and need to be completed in 12 hours from assignment and training. Need a virtual assistant to update 2-4 slides on a PowerPoint similar Google Slides for 19 presentations (duplicate the master slideshow, crop images, change the header, place images on slides that we will supply). Takes a few minutes to update each
I have some work, in an Excel spreadsheet. I want to appoint freelancer to draft an excel file where there are any number of players list The conditions are as below :- to Create Team by picking Max 11 players as per the following combinations (P1,P2,P3 P4) within a budget of 100 credits. Step 2: Create your Team Select players for team from all 4 of the categories mentioned below: WK - Wick...
Specification sheet with cad drawings ( front back side ) of furniture and other interior items E.g, mirrors and chest of drawers . Each product ...side ) of furniture and other interior items E.g, mirrors and chest of drawers . Each product details on one sheet of A4 .very simple . Pls cost per item and for doing spec sheets for 5 items at a time .
I need a quotation in excel, that when y save it with a button made with macros can save the project in pdf, with a consecutive number, name of the client and name of the project as the name of that pdf plus at the same time when i push the save button start a database in another with the project name, client, date, quantity of product and amount. This
Objective = build macro which can compare data from the Sharepoint file to the CMD file and populate in the Sharepoint file the possible customer ID number from the CMD file. Things to consider == 1. Customer name and city should be leveraged to compare the records. 2. Customer names will not be 100% match so need to factor in some variances. As such, consider the following: a. If name is ...
...prefer VB for this, as I will want a UI interface that is clean. I am open to other software, with the exception of below: 1. Python 2. Anything with Java in it's name 3. Macros 4. Any software that needs additional software to work. It's important for you to know that I will be running on Windows Server 2008, that cannot be upgraded. Time frame
We need to create a Macro that Copy Pastes a Certain Value to Line 1 , then Copy Pastes a result from another sheet to the result sheet Under Line 2. ( We have this Macro in place Already. ) The important thing is to do this activity For "X" number of lines but each has to be run One after another otherwise the result cells will show wrong result. Currently i have to go to each Line an...
I am in need of someone who is capable of using Google Sheets and Analytics to create a metrics dashboard (similar to the one attached), including: Social - followers, engagement, conversions etc. Paid - Impressions, reach, CPC, CPM, Click through rate etc. Email - Open rate, unsubscribes, link clicks etc. A similar breakdown for SEO and Retention
Hi Looking for someone to write a simple program to maintain inventory for a small business based on a google spreadsheet. It would prompt the user to enter info, search the sheet, display things, and generally just be a user interface to use the spreadsheet. Attached is what the program needs to do. A sample document of what it will be based on
We have a dashboard that holds some sensitive data on the backend, I need this data to be moved into a seperate workbook and a series on vlookup / Importrange formulas created to make the sheet read from the data workbook. NO more than 10 formula
I need a script in Google Sheets that will grab movie names from 1 column then get post the IMdb ratings and amount of Votes in the column next to it. Picture included for the outcome I am seeking. Thank you.
...flushes (usually more than one per user). We require some data manipulation to be able to produce valuable information for our company. I'm looking for an excel based tool with macros or similar capabilities to analyse data to produce a summary of results, with possibility for certain visual displays. The attached file shows the data we already have, and
Looking for some who can provide an accurate and verified list of the attached excel sheet with contacts in Oman and Kuwait to sell high quality 100% Egyptian Cotton Bed sheets, linen and Towels. I need a list of all the Wholesale, Mega outlets, hotels, hospitals, all other kind hospitality facilities procurement responsible contacts in Oman and Kuwait
...example of what the resulting spreadsheet should be like, along with the data I used to manually create the file. Note that the template spreadsheet contains buttons that run macros that allow additional data to be inputted so in your solution so your solution will most likely need to programatically click those buttons. For example, if the input data
...project information sheets to align with our website ([login to view URL]). We need a simple, native template we can use for future project information sheets as well as some examples designed for us from the list below (the more the better but a minimum of four would be appreciated). Attached are our existing project sheets for reference.
I have a program I am running and would like to record my finger gestures and be able to replay them with exact precision. I a...and would like to record my finger gestures and be able to replay them with exact precision. I am using a Dell Precision M3800 w/Touch Screen. I would need to record multiple macros that I can play back with exact precision.
Please see attached word doc. I need this converted to a user-friendly spreadsheet that we can upload to google drive as google sheets. We need it done immediately please!
Hello, I have a basic spreadsheet already made in the general format of what i want, but i have no clue how to use macros. Basically i need a clickable ‘option buttons’ form, which staff will fill out as an audit. Once they fill out the form, they click sumbit, and the data gets inputted into a database list. The data from that database then needs
I have an Excel file, it has a lot of images in it (thumbnails) When I send this file to a customer in th...to a customer in the USA he can open the file but NOT see any of the images. I have used several file types such as macro enabled and also made sure the guy in the USA has macros enabled... he still cannot see the images. Help required please.
It's a small project based on given data u have to answer 6 questions
I was looking for a program that could actually copy and paste specific folder to its destiny that I will choose, it has to delete older version of files ...that generates them stop working. So I though that copying and pasting could fix my problem. I need the latest numbers to generate something more accurate, i run bunch of macros in excel with it.
I have sales data for 3 months which I need to be sorted into pivots or graphs by product so that I can predict future volumes. I have also some work, in an Excel spreadsh...I need to be sorted into pivots or graphs by product so that I can predict future volumes. I have also some work, in an Excel spreadsheet. Create a database in excel with macros
I have a one-page sell sheet that I need replicated for other products. All pages should match in design. Simply create a replication of the original design, and plug in proper information for the rest of the products. Roughly 30-40 products will need their own one-sheet created from the original design. I have content and graphics ready. Simply need someone to plug data in.
...match two excel sheets! Hi, I have two excel sheets with data of persons. In the second sheet there are more persons than in the first one with data as well. I need the first and second excel sheet matched, so that all informations/ data in the second sheet are added for the persons in the first sheet. To get a precise matching both sheets have three columns
...scripts created to extract data from 2 different websites. Prefer VB, but open to other software, with the exception of the following: a. Anything with Java in it's name b. Macros c. Python I do want a UI to keep things clean. I do NOT want a web based program and the script needs to operate without the browser. I can't have Chrome blowing up and
Proofreading and editing write-ups Create macros using VBA scripting with various files
Proofreading and editing write-ups Create macros using VBA scripting with various files
Maintain date format when export Google Sheets to CSV in GAS
Quality of experience in QTP/UFT Automation Testing, Vb Scripting, Vb Macros, Algorithms and Data Structure. Has an experience on working with SAP, Windows, Web and Mainframe applications along with Tectia, Powershell and Putty. Has good experience on working with Keyword driven and Hybrid Framework and can able to build the one considering the project
1 Workbook w/7worksheets E S M K A C R Worksheet E needs 4 “buttons” to start macros (1 each for worksheets S, M, K, and R) plus will use specified data for each to specify variables for worksheet columns Worksheet K (Run this for all rows (typically 180,000 – 200,00)) Column K has 2 variables that will be text characters defined in Worksheet E,
I have a speadsheet that needs to be moved to about 9 different pdf files. I would like to be able to save and print all docs with a one button click.
...work on both Windows Office & Mac Excel 2016. We use OneDrive, so if any external data sources are required, must be OneDrive (not Google Drive) compatible. Requirements • Excel VBA & Macro expert • Combine multiple sheets into 1, delete duplicates • Delete extra columns • Filter range, then insert row breaks between certain ranges • Conditional f...
We are rebranding and need to have our product data sheets and installation guides laid out in accordance with our new brand guidelines. The dates of the project are as follows: Datasheets (approx. 20): Start 17th September, submit for final proofing by 24th September and complete by 26th September. All content will be supplied with the brand guidelines
The designer has to layout the pages of the Calendar in Indesign. 365 layouts pages (Some pages are already layouted) using the Predefined Styles and also based on the last calender year. The language of the Calender is German and is necessary to take care of the specials character used in German language (ü, ö, ä, Ü, Ö, Ä, ß).