Excel vba code data web page jobs
The freelancer will receive an Excel list with prices to 31 stocks over a period of 3 years. You are asked to create an application, that performs analysis, using Excel and VBA. The number of analysis methods used should be dynamically selectable. The uploaded image shows an example for the GUI. The application should include the methods of technical
when a (certain) email is received, combine the attached pdfs (two or more) into a single pdf, save and name the new pdf based on the original email and save & sen...a single pdf, save and name the new pdf based on the original email and save & send the new pdf as an email attachment. Email program is Outlook, looking for rule based and vba solution.
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
Read from consolidated source excel and write to individual excel template for each day. total reports to be 90 for 140 financial intruments
Got a VBA macro that's pulling duplicates into excel. There are no duplicates on the original website. Some problem is causing it to repeat some data. Need you to fix this behavior so that the macro only gets the data as is.
I am looking for someone smart, who can write Excel vba code, starting immediately. Details will be shared with selected candidates.
I have some work, in an Excel spreadsheet. Looking for VBA into spreadsheet. Want to capture data (back and lay prices)from Bet Angel (Betfair) at chosen optional specific time intervals eg maybe every 5 minutes or 1minute. Therefore eg 1.00pm capture back prices of all horses and put in cells A1-A10 1.05pm now capture back prices of all horses
i need my excel sheet to retrieve data based of a client date of birth and gender from this website [login to view URL] im trying to get their state retirement age.
I have an item spreadsheet that has : Item, Color, Size, Qty on Tab 1 (the data on this tab has multiple repeating records) SKU, ,Item, Color, Size on Tab 2 (the data on this tab is a lookup table) I need a macro to run and do the following : 1. Do a vlookup to Tab 2 and populate the SKU alongside Item, Size, Color, Qty on Tab 1 2. Sum up all repeating
I have an Excel VBA software program that was developed by a freelancer in 2012 (it is a business strategy training simulation) and now need to update and improve the programming. The previous programmer is not available so seeking another resource.
I want to build a standalone softw...standalone software program that incorporate VBA, SQL and SAS code. Possibly Code from R but not imperative. Basically I would need the shell of the program, and I would want to add VBA or SAS code to run models. I want one software program that can compute graphs, charts, stats, export to powerpoint or excel, etc.
Hi Ravi C., I noticed your profile and would like to offer you my project. We can discuss any details over chat. I have a long list in Excel of contacts that needs to be cleaned based on a VBA script that runs through and formats the lists by aligning up the name and email address.
I am interested in fetching shipping rates from Fedex API. I have API credentials. Please let me know if you have done it before. Need to be done in MS Access and VBA. No 3rd part things except fedex api.
Looking for someone savvy with VBA (Excel) - essentially good with macros, and linking this to Word. In need of a workbook that can serve as: 1. an upload tool (for a list of questions) 2. a db sheet Q&A format, for the search tool to search for matching answers to the input questions 3. a functionality that will take the matching questions
I am looking for excel expert. I am going to collect data from website.
The original excel file has one sheet and output should have 3 additional sheets than the original: 1) extra sheet1 (just a selection of columns from original) - date filter 2) extra sheet2 (some pivots should be created in this sheet) 3) extra sheet3 (a new selection of column from original) - date filter 4) vba code should have comments and be explained
If you use the review-feature with word, you can either set the markups to a special color (then *all* changes will have this color) or you can set it per author (then Word chooses the color). The recommodation is, that this color per author is choosable, so that each author has it's own color. This color-setup should be stored localy on the PC, so that - once chosen - this user on that PC a...
If you use the review-feature with word, you can either set the markups to a special color (then *all* changes will have this color) or you can set it per author (then Word chooses the color). The recommodation is, that this color per author is choosable, so that each author has it's own color. This color-setup should be stored localy on the PC, so that - once chosen - this user on that PC a...
Hi, Please bid only if you have experience only. Detail will be share later. It a urgent project so need to start right away
I HAVE AN excel sheet attached which contains 4 sheet 1- p.o 2- invoice 3- payment 4-report for sheet 1,2,3, is all input from user and what i want is a small box to enter p.o number and according extract all details according to p.o # and fill data in report and also to help arranging summation equation in report
I am interested in fetching data from Fedex API through VBA MS Access
The primary function of the excel vba is to extract all the data from a website result query. Currently, there is an error in the script as attached in the image. Please see if you can solve it
The spreadsheet is already working and importing the pictures into rows. I would like to modify code as the pictures to be imported will be conditional as per a cell value e.g. : cell value is 3 Megapixels then below this value the pictures will not be imported
I have Macros Crashing (Sometimes it work some others it crashes) after upgrade from Solidworks 2016 to 2018 , im seeking for some professional to fix this issue via team viewer
I work at an engineering evaluation firm and require a spreadsheet that is to a certain degree automated with macros that use the goal seek function to approximate valu...engineering evaluation firm and require a spreadsheet that is to a certain degree automated with macros that use the goal seek function to approximate values for large sets of data.
I need someone to set up my excel sheet for email notifications
I have some work, in an Excel spreadsheet. Do VBA so my spreadsheet can send out reminder emails
I have a finished vba-code to web scrape soccer results from a website. The structure for the scraping is set, and the code has worked for months, but the problem is that the website has updated its security. So I need to get past the error "permission denied", and make the code more robust, since it also fails by losing it structure when I get past
I have a vba-code to web scrape soccer results from a website. The structure for the scraping is set, and the code has worked for months, but the problem is that the website has updated its security. So I need to get past the error "permission denied", and make the code more robust, since it also fails by losing it structure when I get past 200+ links
I need you to develop some software for me. I would like this software to be developed for Windows using SQL.
I have library records in 35 excel files (each file has 500 records) that I want to copy specific rows only to a new workbook. However, the field headings are on the side in Column A not on top. So I want to copy entire rows where the values in column A are equal some fields only. See the attachment how records are stacked in first column.
...produce several graphs in a sheet. . I need a code written to make the graphs automatically update to show the most recent data to the date shown in cells I1 for MBN and W1 for GRV. (the filter buttons on the chart must be hidden so this needs to be worked into the code) I also need my email Report code update so it ask the user whether it wants to
Hello everyone! I'm looking a freel...me that get all datas(price, product image url, etc) from some AWS shopping sites. You need to have a good skills of creating Python scrapping scripts or VBA. I need excel doc that saved all data from supported sites. Please note "AWS Scrapping" on your head of bid. So I'll consider your correct bid. Best regards!
I have an excel file which have various headers where i have included time stamp in the file which allows me to filter the entries on the basis of the date on which they have been entered in excel file. I want to create an xml file, from the same using vba coding on a prescribed format so that it can be imported in a software.
I want to create a Macro Button that merges two excel spreadsheets and that groups them by unique ID, everything is explained in the following file.
looking for someone who can build a program to assign task to my team
I want to have a VBA Macro that creates a HTML page with interactive Charts. In the attachments you can find a Scource and a Result example.
Have written a code for a user form to automatically add information (delivery details) into a database, however code only currently works if all the boxes in the userform are filled, need this corrected so that form will work regardless of whether all the boxes on the form are filled or not.
Need a Bidder for a long term who can bring leads in excel work, vba, ecommerce, webscrabing, graphic design.. every bidder will be in commission based for a long term with monthly commission for every project they take
Hi, I have encounter this minor error and i have uploaded the excel vba script and the error image. Error1 is the error message and error2 is what appears upon debugging Budget: $25
I want VBA code to scap data from an application HTML This is basic stuff: * Open web application * Enter userID * Select Menu * Select Sub Menu * Select Sub Sub menu * Type a inventory reference * Scrap results This may require one hour sitting together while you develop and test Because you will not have access to the application, I will be opening
Need to download data from Web page to excel
We want to have a database developed on MS Access to record data on power purchase transactions . The developer needs to design tables,queries and forms to enable the user easy access of customizable reports. VBA programming will be needed. Audit trail feature shall be there.
...software (C++, C#, Java, VBA, ect.) and why you think this is the best choice in for this case. 2. Describe in 2-3 sentences the main objective of this project just to proof that you have read the entire document and that you have understood the topic of this project 3. Tell me at least one way how you could access the data fields of the form on the
Excel macros play an important role to perform repetitive operations in excel. It takes lot of time, when handled manually. I have done quite good amount of work in excel macro handling. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, Image handling, Shapes variation, Pivot Tables, Text to columns
Need some modifications on existing Microsoft Access Database that has Visual basic as well. The project need to be completed remotely on my machine only.