Attached is a spreadsheet that has readings from the new data site. Every site can have up to 3 sensors (identified by a sensor #) connected to a base (identified by a base #). I need a blank spreadsheet where the user can input the following: Input: Base #, Sensor # (or all sensors connected to that base), Date (single date). The spreadsheet would generat...
Need to build a FULL Excel Based Application that interfaces with an Accounting Application. Pulling data via ODBC connection and re-inputting via API.
Microsoft Excel VBA coding that needs 1. Add, update and retrieve member’s details such as name, date of birth, NRIC, contact number, residential address, email address, etc. 2. Member must be at least 18 years of age. 3. One-time membership fees of $50. Payment by cash or credit card. 4. Discount rates to member i. 5% discount to the total purchase
I need for multiple VBA modules to be converted to C# and compiled into two standalone addins. Part of this will require for the user to be able to perform CRUD operations to SharePoint online lists, which will require for the users login credentials to be passed automatically when necessary.
Trying to create/populate a database using historical racing results. Need to scrape data (tables) from website into MS Excel. All details in attached MS Word document.
Trying to create/populate a database using historical racing results. Need to scrape data (tables) from website into MS Excel. All details in attached MS Word document.
Dear all, I need a vba run excel file manager to be drafted with following functionality: 1/ list file names from the selected folder + subfolders 2/ list location of the file 3/ hyperlink to the file 4/ once list is generated, ability to change file names in the list that would automatically change names in selected folder and subfolders. So basically
...(geotechnical). Actualmente, estamos trabajando con Microsoft Excel para registrar y hacer cálculos de los ensayos, los cuales estamos modificando constantemente a fin de garantizar la trazabilidad de los resultados. En este sentido, llegamos a un punto que necesitamos ayuda de un experto en Excel VBA, a fin de programar una serie de formularios y hacer los
I need someone to write a VBA coded workbook that can auto calculate and pull values from within the workbook and display them according to date
Need Vba Expert to create module to extract page from pdf file and email based on criteria Max 2 hrs work for expert
I have an existing Excel spreadsheet which sends emails through Microsoft outlook on a PC. I need the spreadsheet updated so it works on a Mac and sends the emails through the Mac email application
I have an existing Excel spreadsheet which sends emails through Microsoft outlook on a PC. I need the spreadsheet updated so it works on a Mac and sends the emails through the Mac email application
I have an existing Excel spreadsheet which sends emails through Microsoft outlook on a PC. I need the spreadsheet updated so it works on a Mac and sends the emails through the Mac email application
I have an existing Excel spreadsheet which sends emails through Microsoft outlook on a PC. I need the spreadsheet updated so it works on a Mac and sends the emails through the Mac email application
I have an existing Excel spreadsheet which sends emails through Microsoft outlook on a PC. I need the spreadsheet updated so it works on a Mac and sends the emails through the Mac email application
I have an existing Excel spreadsheet which sends emails through Microsoft outlook on a PC. I need the spreadsheet updated so it works on a Mac and sends the emails through the Mac email application
I have an existing Excel spreadsheet which sends emails through Microsoft outlook on a PC. I need the spreadsheet updated so it works on a Mac and sends the emails through the Mac email application
I have an existing Excel spreadsheet which sends emails through Microsoft outlook on a PC. I need the spreadsheet updated so it works on a Mac and sends the emails through the Mac email application
Hallo Wir benötigen jemanden, der uns hinsichtlich eines VBA Projektes hilft bzw. jemanden, der uns gewisse Automatisierungen per Makro programmiert. Zur Aufgabe: Bei dem Excel anbei handelt es sich um Daten für den Monatsabschluss. Sobald dieser abgeschlossen ist, soll eine Mail generiert werden, die den Link (Hyperlink) zum jeweiligen Abschluss-Ordner
I need to manipulate a data file I will receive each month (similar to attached). The data file includes a list of managers (Column B-D) and all of his direct reports (Columns H-AB). I want the file to create a table from the original showing a summary table detailing each managers direct reports on a seperate row (see summary sheet for example). The example below has 3 rows of data, but the ac...
Trying to run multiple reports off of a button push that filters data by date and then copies the data depending on criteria. So attached is "Book 1". It has 3 Sheets. A "Tasked" sheet that shows what work orders have been given to employees, a "Total Tickets" sheet that shows all work orders that have been received, and a "MACRO" page with date ranges for...
We have an Excel file with macros (XLSM). Download resource manager for excel from [login to view URL] Problem happens across multiple versions of Excel and OS. When downloaded from our website, or emailed, and the user tries to open the xlsm file, the first prompt is for: ENABLE EDITING After you click this, to enable
I have an Excel-VBA work that was desgined for 32 bits. I need to transform it in a 64 bits formar
Microsoft Access module(s) needed to get Amazon orders XML from Amazon MWS. Module needs to get all orders from last 30 days and parse xml, append data to a table but only if not already there. (new only based on AmazonOrderID). Important: Your module needs to create the Signature MWS requires for each unique request. Module also needs to have function to get one order xml info but AmazonOrder...
i have some simple formulas on excel sheet & want when some certain condition meet it show pop up window.
i have some simple formulas on excel sheet & want when some certain condition meet it show pop up window.
I want to take several hundred rows of Excel data and create a Powerpoint slide for each row through VBA. This project has a sample Excel file with 3 records, and a sample Powerpoint slide from the first record. The text goes in a text box on the left side, and the image link needs to go on the right side, preferably scaled to about half the slide
Need to dynamically filter from drop down list in excel table. Need vba code w/ description/notes of code so new users can understand. Looking to dynamically filter the table ("Table") in file (also outlined by black bold line) based off the drop down menu highlighted at top of file. Bonus would be to add signature blocks and note page on how to send
I'm in need of assistance with a sales tool my company has created for our clients. It's an Excel spreadsheet our clients use to track their sales process. I'm having a hard with with programming the spreadsheet to automatically populate the summary charts on the first tab and some conditional formatting issues. Looking for help on a few spreadsheets
From an existing Excel sheet read the path of a locally stored file from a cell. Copy the Thumbnail from that locally store location and append to a new cell. Then in a new cell create a link to the file that opens it when clicked on.
I need someone to write a routine to create a report based on defined rules using multiple excel files that will be received by e-mail. Report should be displayed as on the REPORT tab of attached file. This is made up of adding data from pivot tables from multiple data sources. All data to be received from 4 original files that will be received by e-mail
Example: www.colgate.com. Want to scale to 200+ websites. Need automated scripts with APIs / VBA / python to find out information about multiple sites including. Pages, headers, page download speed, download waterfall, 404 links, errors, etc. Ideally will use free websites/tools such as [login to view URL], screamingfrog, [login to view URL], https://testmysite
I would like to use customer filter and get the total quantity of the result. For instance i will select "BW" under "Invoiced By" and select certain product from "Product Name" drop down. Then I need the total quantity as a result. I need to have the option to add multiple filter from multiple column and get the quantity. Please check the attached file for sample d...
I hired an access developer on here who just disappeared and I need someone with solid VBA experience to resolve some issues with the database that were not completed. Once the database has been completed and can be used without any errors, we'll need to have all the data migrated from the old version of the database to the new database. I will provide
Small start up looking for a freelancer who has experience in VBA for excel to assist with a issue we are having with our customer order upload process.
I have an access DB very sensitive information, I could be fined several if this data is being disclosed, I have several tables that need to be join on two simple Queries using join and unions and compare both to come with and output result in access everything has been done but need to be twicked the Queries just to display unique results that are not equals in one table, let me know thanks
I need someone to build a really simple excel macro to make requests to amazon's seller api. It's very important that all code used is vba and that it's a macro, not a plugin, since we are trying to build a consumer facing product and don't want them to have to deal with installing any plugins. Ideally, it should be able to run on windows or a mac
I need someone to build a really simple excel macro to make requests to amazon's seller api. It's very important that all code used is vba and that it's a macro, not a plugin, since we are trying to build a consumer facing product and don't want them to have to deal with installing any plugins. Ideally, it should be able to run on windows or a mac
I need someone to build a really simple excel macro to make requests to amazon's seller api. It's very important that all code used is vba and that it's a macro, not a plugin, since we are trying to build a consumer facing product and don't want them to have to deal with installing any plugins. Ideally, it should be able to run on windows or a mac
I am a surveyor and I need to ...my time. I do have the report format in word but I need to build an excel report with formulas, macros and vba's to finish my work in very short time. I do have the idea, but need an excel macro vba expert to convert my idea to reality. I attached a sample report format. Any excel vba macro experts, please let me know.
I need you to develop some software for me. I would like this software to be developed for Windows . Develop an Excel application using VBA
I want a small subroutine developed in a Word document to search for tables and cells and then to transfer pieces of text within the document and to fill in one document property field. Also to customise ribbon with a button to run the subroutine
I am looking for someone to help me learn VBA for creating financial macros and workbooks to improve processing times.
Hi All, Please see the attached file. The project...welcome to clarify your doubts, but please ensure you have read & understood the attached sample file. It would require some bit of excel VBA coding skills and mathematical aptitude. The solution is required in an excel. This might be one of the many challenges I would be putting up. Cheers,
I need an excel macro able to replace a cell value from looping through a list in another sheet and save the sheet every time the sheet change.
Boa tarde, Tenho ficheiro onde através de um formulário ele guarda os dados do mesmo numa tabela à parte, no entanto precisava que ao pressionar enviar, o formulário além de guardar os dados nessa tabela, enviasse também por mail todo o conteúdo, ou seja, o texto e imagens. Além disso gostava também que o mail assumisse no assunto e no...
If the FIRST 6 characters in column D from "Sheet 2" match the FIRST 6 characters in column K from "Sheet 1", then paste Column B from "Sheet 2" into Column C "Sheet 1". See attached sample.
...project**** "VBA Selenium" Expert is required to complete the below simple process: 1. Use the attached Excel form to complete the code 2. Access the Container Number and enter the TextBox1 value (use this BEAU440873) 3. Submit 4. Pick the information from the table under "Discharge" (Vessel name, voyage number, Designation, etc.) 5. Update the Excel t...
