Small personal project: need to scrape this simple website for HTML table for statistical analysis [login to view URL] Scraped output to be populated into SQL tables (schema = Date (mmm-yy) | Product Type | Price) SQL SSMS preferred, MySQL also OK
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.
...headers and fields in Word do 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 selectabl...
Hello, I have a table in sheet 1 and want in sheet 2 a formula which is connected to a filter which shows me depending on the filter I choose in sheet 2 only particular rows from sheet 1. Sheet 1 will be 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
I ...userform to enter and update details, as well as the reporting functionality on a seperate userform as seen here [login to view URL] Please note there are some differences to my sheet and the tutorial sheet. We do NOT need Grade or Department, but we DO need extra fields for Username & Password
I need help reformatting Excel tables and ...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
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 4
...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.
===> Should have expert knowledge in Oracle table partitioning and performance tuning NOTE: Confidential -------------------------------- For purging sub-partitions, we shall have purge profiles. We have around 2000 bank's... should be distributed among the purge profiles... purge profile 30 days... 60 days... 90 days... we shall have column retprofile
I received an email that has HTML table within it with inline stylings etc. The table is in the screenshot. I need this converted to bootstrap responsive theme, and styling moved to a separate css file. Bid only if you can do it. You will have to write it from scratch based on the screenshots I give you. The one now attached is just an example, there's
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 is the return as a percentage.
...io/[login to view URL] downloadable here [login to view URL] . How the counter should run: Every member who wants to join is entered in a mysql table. After that (entry date), he will be displayed with the others on webpage. Imagine the demo above, every square is a member (next to all others). The square shows photo, name
...(including folders). I have tried to pass this to a JSP page, so I can print the fileList in a HTML table using bootstrap. However, I am having no luck. The following files are what I have so far. I may also want to also add the size of each file in the table too but will discuss that further once this first part is done. I don't use an IDE, I use Jedit
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 Insert Sql procedure in SQL Database. I want to map this sql store procedure in Entity Frame Work Table Mapping with Insert Function. Problem here is procedure is having three output parameter which should get mapped in Table Mapping of EF. Please also write small function where [login to view URL]() is called and function is able to receive the
Looking for someone to do more jobs with.
data table design, I am looking for a designer, for data table, I need a better look and clear. html It is not much work and can be completed in 1 - 2 days. only serious offers, thank you very much
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
...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): [login to view URL] I am including the excel file with the code. You will see the macro operating
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...
...used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs whatever i do. table wont let me add a new row.. wont accept any varchar. it only admits text.. i have 230 rows in table.. and need to add 100 more... i attched the table. you
PHP script to migrate a view from microsoft sql server to a MySQL table. Attached sql view structure.
I uploaded a chart that shows X / Y and I need to change the percentages and make them accurate. The seller is offering a cash certificate and he is giving out 30% discount ( $15 on $50) BUT the 30% is ONLY on the first $50 spent!!! So if the buyer spends $100 the money spent above $50 is NOT Discounted so the REAL or EFFECTIVE discount the seller is really giving out is only 15%. ( $15 on $1...
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 even I provide hundreds of account details and it should set up all of the accounts in the same profile. Thanks.
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.
...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 working
I need a Woocomerce expert to quickly show me how to make a particular woocomerce table responsive on the order-pay page. This works fine on desktop devices, but the table is not responsive on mobile devices which is quite disturbing. I need this done immediately. Please note that you will have to tell me the fix or log in remotely to my computer
VBA Code for Form Filling, from an excel table Hello, I'm needing a vba code that fills out a form on a page on my company's intranet. We are talking about a Human Resources sector In excel I have the personal registration(ID), name, note and description On the intranet page, the code needs to copy the excel personal registration(ID) and click on
hello I'm looking for a developer that can do a crud java script and firebase, Basically it's save, names, surnames, phone, upload your profile image and upload another 5 alternative images to firebase storage
Phase 1: Data Staging from Stock Exchange file or API with applied calculations using Combinatorics. Output in webapp or excel