Hello, I'm creating a VBA macro to search on 40-50 websites (fill search field, click search) and import results in my excel file. my macro is working for one website but i would like to work in 1 click for all websites My goals is to put a partnumber in a search field in my excel then click on a button and all data to be shown in another page
hi guys i need a vba code which will spilt the file into multiple PDF file based on Heading and sub headings in word doc. Also it would save the file based on heading as file name and make sure heading title does not change.
I've got Excel VBA code to web scrape. I now need to use proxies and speed up the process. Should be easy for someone who's done this before. So I just need the Excel VBA code snippet to use proxies. The proxy list can be in an excel file as attached. I've attached a file to explain. 1 - get url 2 - get proxy from list 3 - use proxy to get data ...
I will make payment on hourly scheme ONLY through the website. No direct payments will be made including through paypal or some other similar option. The data can contain upto 4000 rows and has two columns – date and value. Input date I1 has to be validated and the user should be prompted to enter the date in the range or exit the program without crashing. First purchase of quantity I2 will...
I am looking for some help with a MS Excel productivity spreadsheet for our Onion Packhouse Specifically to transfer data from one sheet to the next using VBA etc I would like the some of the data from sheet 1 to be automatically be transferred to sheet 2 so sheet 1 remains clear for daily entry only and sheet 2 keeps a running total of productivity
I have data in excel with two columns date and value. I need to do a what if analysis. That needs to accept some variables. I will enter a date, initial quantity, a percentage difference when that action needs to be repeated, a factor that multiplies the initial quantity. I need to know what is the average price on each of the entry dates and what
Program will do: 1-Unzip all the files in one folder 2-Merge all the txt files, make one excel file 3-Provide one excel file separated on the base of | symbol. Kindly check Example of the zip file need to unzip and a solution required at the end.
An excel file with 11 tabs. The coder will create code so the user can add and delete rows with specific characteristics The coder will create code so the values entered in certain fields are summed to other worksheets
I want a twilio interface that uses classic vba from access and excel 1. a table, xl sheet with a list of phone number 2. i click on a p;hone number, the prompt is phone ot text (i can do all the vba interfaces, i need the twilio rest api done) 3. if it is a call, the call flow .. calls me, when i answer, connect the call to the client 4. when i
Hi, I need someone to help with the creation of 5 spreadsheets. I attach one template for reference. I need this for: English Premier League English Championship Italian Serie A Spanish La Liga German Bundesliga I need to pull in fixtures from the below link to my spreadsheet. This file will need to be filtered depending on the Spreadsheet template being used. [login to view URL] For example,...
I have an access based contacts database that comprises UI as well. I need a VBA / MS Access expert to analyze/optimize the VBA codes in the DB. Also, there is a functionality that has to be updated, which can trigger the change in DB structure and source code accordingly. This functionality shows if a postcard was sent to the selected manager’s contacts
Need smart , experienced , Excel VBA coder , to START by writing a simple if then else macro . If last 9 to 18 rows is rising for x percent , then keep the U Verdict else Neutralise it with N . If selected will work at 50 dollars an hour for hedge funds and Binance Platforms . Primary Experience in VBA excel macro Essential . Secondary Experience
...6-a2be20ce2fd9/convert-contents-of-a-formatted-excel-cell-to-html-format?forum=isvvba It works perfectly, but is very slow as it steps through each cell one at a time. e.g. to covert a single 1000 character cell, it takes about 10 seconds on my fast computer. I found a fix I think, but I need a VBA expert to do it for me (or find a fix that will):
A small job. Need someone to make a excel-macro (or any other way it can be done) to do a series of calculations on a sheet of excel workbook. It's a small job. Details will be discussed.
Hi, if you know Excel, Word and VBA, this one is easy! Here is the program flow: 1) User enters First Name, Last Name, Address, City, Province, Postalcode into Excel (columns) 2) Clicks a button "Create Letters" and for each row that has a column "Already Printed?" marked "No" it takes a Word Template and merges the fields in for t...
I need a macro that can extract data from a PDF invoice to a Excel file.
I need a VBA or other type of programming to add multiple accounts into MS Outlook (2007 and above). The account details can be entered in an Excel sheet. VBA should manage account creation for me. Thanks.
Want to scrap the gaming site - ONLY Macro expert bid -Want to scrap from VBA only . Please bid. Details will be shared with winning bidder.
Hi, I am creating an excel userform based tool and would like to hire someone who is proficient in excel, userforms and VBA. This project is expected to last for around 2 months full time(significantly less for a person who has great VBA skills).l I know exactly what is required to be built and have a Proof-of-concept with the code already ready and
Phase 1: Data Staging from Stock Exchange file or API with applied calculations using Combinatorics. Output in webapp or excel
I have ongoing work related to our previous project 'I need an Excel expert to help me find a solution to this problem via a formula or macro'
I need very simple code....unmatched it needs to Append those unique "Quote Numbers" into the tblProposalStatus. (There should not be Duplicate "Quote Numbers" in the tblProposalStatus Table.) I need VBA Code. So I can take what you submit and paste it into an event action (button: on Click) Private Sub CmdRunButton1_Click() Your Code Here End Sub
Quick description: I need an excel macro that compare key words in a matrix and if found an X in the matrix it should write this down. The script needs to run under excel 2010 Take a look at the attached excel test file detailed step by step: (Input) copy Range A to G -> (Output) A to G CounterOutputRow = 1 Loop (until (Output) Cell A of row <CounterOutputRo...
set a timer in an excel worksheet, once condition met in the worksheet1, copy and paste certain data to MS outlook and send it out everyday , back to workbook, create a worksheet2 and name it (mmddyy the date we create) save the data(we send to outlook) in the same workbook in the attached excel, if G3 >10%, copy A3:E3 to outlook again if G4>10%
Extract data from a website with pagination. Need to get the data to Excel file. Not a complex data extract, but since it has pagination I am not able to get it using available tools. Developer with Excel VBA knowledge & web extracts should be able to do it easily.
Make me a Macro / VBA / Program To be able to Nest objects in corel draw into a given size area, and be able to dictate what gap to have between the objects, and also dictate the gap between the given area and the objects So in short I want to be able to for example: create an oblong box in corel draw, I have objects on the page that I want to nest
Hi, I need a pro in excel. I want a button placed on sheet 1 that when pressed all of the data (that is a number not words) from column a goes to sheet 2. As well as some pre determined static data to create a template. Thanks, Matt
...where it can be uploaded into our systems either in EDI or excel format. However, not all terminals in the world today are able to produce the TDRs in the TPFREP format, hence a number of locations worldwide are still sending their TDRs in their own formats. The task is to be able to write a VBA code to convert the TDRs from those terminals not able to
...a trusted workbook. 2. Add 4 offerings to a drop-down class menu. (I'll provide the additional information in more detail once hired) 3. Between columns 'AG' Add macro buttons or VBA for an interactive dynamic list of classes that prompt the existing dynamic calendars in the same way the drop-down class menu already does. Can have list print on second
I need you to develop some software for me. I want a Microsoft Macro enabled document that can remotely collect browser cached information. I would like this software to be developed for Windows, IOS and Android using Python or any other.
For an excel which can have 10-5.000 sheets there are values in each sheet (these values are always in the same cells). I want to add values to each sheet based on formulas I already have. These formulas should just be copy-pasted on every sheet After that, I want to add a 11 extra sheets with summaries of these existing sheets. Within each of