Project 1A: Add missing JS formula for a... Estimated hours: 3hrs. Project 1B: Data restructuring and API integration into 4 sheets. Estimated hours: 8hrs. Project 2: Data restructuring and API integration into 7 sheets. Estimated hours: 30hrs. Project 3: Data restructuring and API integration into 20 sheets. Estimated hours: 80hrs. Project 4: tbd.
...files into 1 structured report split over 2 cost centres (1 XML and CSV for each cost centre) XML Data will change daily (will have the same file name and location) VBA code written to pull in the XML file, refresh all data and export the report saved as .xls STEP 2: Use the saved daily reports to automate the production of both a weekly
Work needed on a google sheets workbook used for sales, inventory, reporting for a shop. Currently a lot of the processes are manual e.g sales entry. A form for sales entry is desired. If possible we need a way to hide sensitive tabs from employees whose only job is to enter sales. We have a form takes care of inventory coming and leaving the warehouse
Hi there, I'm looking for someone to build a tool that uses VBA or excel functions to call bing API and retrieve the first result then log in the domain name Basically, I have a list of companies and I need to get the domain name of each. e.g. I have a company name "Midmac" and I need someone to call out Bing API on the search term "Midmac", retrieve
Cells currently shows #ERROR! Remove the =+ in the error cells to just show the number. Example #ERROR! is =+123456789 Cell needs to read 123456789 2001 cells total. Cells position on spread sheet need to be same. Accuracy a must Please confirm understanding
Please read and bid exactly what you would like for this project, no time for negotiations We would like to revise the attached template to use for future reports: 1. Using the column A "Student_Number" from the first sheet labeled "Data" 2. date of the assessment (column W) from the "SR sheet" for the first assessment of the client by date to be listed in column i ...
I need a google form coded into my website, not a google form linked or embedded, the same workflow with output to a google sheet but run purely on my website hosted by Squarespace. I just want the same series of custom fields all on the same page that clients can complete and submit which then populates a google sheet with the data to be picked up by another app from there.
I need you to fill in a spreadsheet with data. we have 100 to 120 pages.
Im working on a project that has a lot of excel calcualtions , sheets and formulas. I need to automate the process to make it a little more user friendly. I have some basic knowledge of VBA but am havign trouble figuring out the best way to streamline my project.
Good day, I want to hire someone who will be able to create me a point of sale system through excel vba. It must be able to meet the following requirements. 1.) Add inventory and price 2.) Keep track of customer listing and sales 3.) Create payment receipt 4.) Inventory count where an email can be sent if it is at the minimum 5.) Sales report for
...will be able to assist me with creating a VBA excel add in that I am able to push data from an excel to a google spreadsheet and vice versa pull data from an google spreadsheet back to excel. I want to have my colleagues be able to update through excel and if I am on the go make changes through google sheets and sync. I know that macros won'...
I have a VBA userform that reads data from a sheet of over 200,000 entries with over 200 columns per entry. I need to convert this into a website that can be sorted, filtered and searched like in Excel. Also need the ability to import CSV files to add to or merge with the existing data if it already exists. Ability to export refined search data as
I have Excel hotel meetings game created in .xls format (around 2006) and it now doesn't run, throwing up a runtime error everytime I open it in Excel 2016 on a Mac and PC. I need a VBA expert to review the macro's and VBA code and fix the game so it runs on both Mac and PC on in the latest versions of Excel.
Looking for a quick and efficient data entry specialist to carry data from a Facebook profile to Google Sheet. Data includes date, content, interactions (like &comments), engagement ranking, post type, topic.
Soy un gestor de soluciones. Requiero migrar una macro de word (vba) a un ADDIN en C# con todas la funcionalidades de la macro. De facil instalacion asi como su mantenimiento. Esta solución debe incluir Fuentes, manual.
Hi We have a small scraping macro written in VBA which takes [login to view URL] game ID from column D and scrapes data to Excel for respective cells (so for example for ID 1402510 it will scrape data from [login to view URL]) However there are some minor issues with this macro. One of them is scraping data when betting market was
I want someone to scrap data automatically from the given financial websites using EXCEL Macro. Then apply some formulas to calculate some desired output. The macro should be fast to bring the output. Use the graphs Below are some websites for your reference [login to view URL] [login to view URL] https://www
...our warehouse on a google sheet with item information and quantity on hand. Just under 400 different items total at the moment. I want to create 'incoming' and 'outgoing' sheets to fill out that will add or subtract to the master list and save as a separate file as a record. For example. IN001 on 5/23/2018 shows the 10 different items that were added
Google Forms are setup to store form submissions in one google sheet. However, its possible to store results in individual sheets using a script. This is something I have seen done but I am not able to build that script. Should be pretty simple for someone familiar with Google Drive and scripts.
...working on a personal project where i have an excel sheet (call it input sheet) with 4 columns and several rows (not fixed). I need a program which on click can sort out rows in desired order (based on a key word in second column e.g. 'Design', Test', 'Material' etc. and desired format. Results shall be in new excel sheet (call it output sheet). Output she...
Looking for freelancer who can visit our office and do VBA work as per requirement of the head of department, should be good in advance excell, macros, developing applications, maintaining computer system, collecting data, set of reports.
make VBA-function to request simple informatie from 2 sites/webgrabbing. Often I have to look on 2 sites, type some inputvar to get a value. I want to automate that request in MS Access 2010, for future requests. The 2 sites are: [login to view URL] (fill in a zipcode+housenumber to get a energy label of the house) [login to view URL]
...forms---so it is ready to reuse. (see link for the form) [login to view URL] I really don’t need the document saved as a template since that has been problematic in the past. This video below shows how to code the for the Checkboxes in Microsoft Word. That would To prevent the end user from accidentally
...be from any site. Example provided is Marina 01. Each Submission document will be in a different file with different file name. So macro should prompt user to encode the site code and it should prompt user to select the particular file and run the process. If it doesnt match with the user input then macro should notify to the user. (Related charts and
Hi... We would like to design a front end user form using the existing excel sheet. We have done all the formulae and calculations. You must able to convert this set of info using vba and design the form. Its manufacturing parts assembly form. Data will be shared during our discussion.
We have a inventory google sheet that we manually put in and subtract inventory from. We need an automated way to subtract inventory when it is taken out. A script or form would be ideal. Perhaps a separate tab where additions and subtractions are made and then they reflect the change on the inventory tab.
I need form fill...that I think explains how to do this using google sheets and Google tag manager, but it is a little high level for me. See below for the link on what I mean. If this is what I am looking for I would be happy to pay someone to implement this for me. [login to view URL]
..."Rates" sheets are for reference for the calculations. We want the drop down menu “Item" and “Model" on the Bid Sheet to select the appropriate item on the “Products/Services" sheet and “Rates” sheet and fill in the price each and labor hours for the appropriate drop down item. In the examples given (A4 through F4) we were only abl...
I have an Access database with tables, queries, forms (with vba code sometimes) and reports. This database now is sepparated by 2 access files. One with tables, and other with all rest, because we need to work some persons with this database. But some tables are very big, and queries sometimes are slow to load. Now only one person work on database
I need you to fill in a spreadsheet with data. we have 100 to 120 pages.
...are not limited to the following: - Microsoft applications: Excel, Word, Power point etc.. - PDF Fillable Forms: PDF creation, editing with scripting using Adobe Pro DC. - Data entry – PDF to word, PDF to excel, - Web Scraping - Data to CSV and image extraction using IMacros, VBA Macros, Zillow Zestimate, Yelp,YellowPages,Houzz, Sport sites.
Hello, I Need to copy data from pdf to excel using macro. Pdf have some data including image form which need to be copied in excel . More details will be given to selected freelancer. Happy bidding. Thanks
Must be fluent English persona and have phone account so we can chat. We require Data completed Immediately or at least 12 hours.
...(mismos que pueden ser visibles con Open Office) hacia un libro de Excel por medio de código VBA. Tengo muchas tablas de este tipo de las cuales necesito extraer información, entonces el número de filas y columnas con contenido sería variable Anexo un ejemplo de mis archivos .dbf y un Excel que reflejaría el producto final Un manual con ...
Need help writing a vba code to import a tab delimited text file into an array, return the list of clients that has matched email address for population as value for a listbox control in outlook vba. Please refer to attached file, there's 3 columns of data: client, address and email. Code to 1. import tab delimited file into array. 2. search through
...such MS Outlook for sharing database and avoid duplicates and usage of this template over internet online such at sharepoint!.... Of course that study would require some VBA and SQL scripts, cloud and security information feedback for the developer. Just to imagine what we are looking for: The project is similar in MS access 2007 templates list
I have to set a relay controlled by arduino from a condition processed by vba access