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.
...not automatically update so I currently have a Word based VBA macro which does this for single file the when the code runs – it also applies a standard font to all the text. Then it saves the file and closes it. All I require to do is automate this by replicate this code within VBA Excel for all Word files in a selectable folder. Typically 100 Word
Hello, I...replaced monthly. Sheet 2 should be programmed that it pulls the numbers from sheet 1. An easy way to illustrate is Pivot table. The only thing is that I need this all formula based, maybe via VBA or Macro. So that always when the sheet 1 1 is being replaced by a new report I click on a button in sheet 2 and it gives me what I want to see.
I need someone to create an Excel staff training database. I have been following a tutorial ([login to view URL]) Please see video for the functionality i am looking for [login to view URL] I have already created a workbook and a User Form in Visual Basic, but i cant program
I need help reformatting Excel tables and graphs. The Print Area selection and Print commands cause the program to freeze. Please do not respond unless you are an expert in graphs. Being an expert in VBA and macros is not relevant to this particular project. I won't select a contractor for one week for this project due to travel.
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
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 - u...
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
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
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 Exp...
...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 the letter (add...
I need a macro that can extract data from a PDF invoice to a Excel file.
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
Hello i need to calculate, in excel, many conditions and keep the profit margin at least 20%. The varibable are . Shipping cost . Product cost . Free shipping rate The product more cheap cost 1€/kg The markup is 50% The fix costs are 3€ The shipping cost depend from weight The free shipping is when order total is > 39€ The module is already done
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. But need it NOW. I have two tables "Quote Master Table" and "tblProposalStatus". Both have a field in it named "Quote Number". And there is a Field in the "Quote Master Table" named "Bid Status". Those are the exact names. (Note: I cannot change the names of the tables or fields, so please don't as...
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 <C...
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
...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