I’ll try to explain this the best I can. I want to setup 3 loops to pull data for college basketball games. I'm experienced in VBA but I'm having trouble creating a loop that does not error out after 15 games or so. There is some kind of security on the ncaa's site that prevents this type of data scraping I'm told. The workaround which has been mostly
I need an excel vba expert to write a two phase code for me, with the first phase being to import data from two different workbooks based on a userform where a certain value is entered, and the second phase to import data from another workbook based on certain letters that are entered for the value talked about in the first phase
I am having a hard time creating a macro to ‘call’ a SharePoint. I am needing a VBA Excel macro code to ‘call’ a SharePoint so I can chose a file within the SP and have it automatically populate to a tab within the Excel spreadsheet.
Hi, I receive constantly a data sheet that is always in the same format. The problem is that it is not a proper table and I need to amend it man...receive constantly a data sheet that is always in the same format. The problem is that it is not a proper table and I need to amend it manually. I would like to have a little VBA code that does it for me.
As attachment you will find my pythonscript. The functionality right now : Find word "ButtonXX", replace with random word from [login to view URL] I need it extended to do the following : replace all keywords from 1 line in [login to view URL] with a word from [login to view URL] .and mark the word as used. For example : Line1 in [login to view URL] is "UserApiKey", [login...
I would like to add data into Google Sheet from Solidworks. I'm using SolidWorks to make techn...data to Google Sheet and store files in Google Drive. I would like to have work done in two steps: 1. Populate new row in Google Sheet with data sent from Solidworks Macro (VBA, C#) 2. Save files to Google Drive and make link to the files in Google Sheet
The site is: https://pubchem.ncbi.nlm.nih.gov/compound/Triasulfuron#section=Top Input will be a list of chemicals. You need to search for that chemical and extract the data in the attached format. Note that the download tab contains a list of files that need to be downloaded for each chemical. Out of this only the patents file needs to be downloaded for each compound. Please bid only after you ...
...am using POST. Currently I have a form that the user submits with a begin date and an end date. Works perfectly as is but I want to be able to store the dates in SESSION so that it can be transferred to other pages so the user can use the stored dates until new dates are submitting. I have a search form on each page. Help is only needed on two pages to
I need to loop through each row and for any cells that meet the "if" condition, then the cell value 6 columns to the left is displayed....to the left is displayed. I already have the entire code written that can email me the cell values, just needs small modification. Should only take 5 minutes for experienced VBA programmer. Need this done in 1 hour.
...flows between certain dates. For example, I want to calculate the IRR for Investment A between 01/16/2018 to 5/20/2018 with the following cash flows: Investments Dates Amounts A 01/15/18 ($55) B 01/18/18 ($20) B 01/19/18 $9 B 04/06/18 $6 A 04/08/18 $24 A 05/20/18 $40 B 05/21/18 $7 A 05/23/18 ($5) Start 01/16/18 End 05/20/18 The challenge
We are searching for a experienced developer who has knowledge in both MS Access VBA and one other language such as Python/Rails/PHP. The goal of this process is to achieve the same functionality as before. Please don´t write a long list of accomplishments in your application but rather give me a short explanation how you would handle that problemset
The site is: https://pubchem.ncbi.nlm.nih.gov/compound/Triasulfuron#section=Top Input will be a list of chemicals. You need to search for that chemical and extract the data in the attached format. Note that the download tab contains a list of files that need to be downloaded for each chemical Please bid only after you have gone through the attachment
...straight forward. This is the only workaround so please read carefully...I am budgeting for one day's worth of effort. We will need screenshare. I will need for you to give me the VBA script based upon the review of the website. I will enter into excel and get the [login to view URL] I'm on VPN this is the only way. I have to accomplish as if I was running my own
I have 4 excel macros running on windows 7 that need to be rebuilt so they will run correctly on windows 10 system. Issues to be resolved: 1) auto run the Excel tasks every 3 hrs (using Windows Task Scheduler - or other app(?) if Task Scheduler is not stable) 2) avoid memory leaks 3) ensure that data imported from source CSV's is fully loaded before running excel functions 4) provide notes s...
Hi, need your support to adjust vrp (vehicle routing planning)model available in the next website to our business needs in less than 1 week: [login to view URL] 1st step/timeline: 1. Add one place as truck parking for the entire network, as origin/destination point for each day 2. Add a daily delivery target
create sticker from logo, create product pic, and adjust existing product pic
This is a project for a public school. We need to adjust a few files as follows. 1. Take VECTOR artwork supplied and change colors and artwork to match [login to view URL] to create new artwork with clean lines between trees and gradiated background. 2. Scale to create artwork panels for gates as per Measurements as follows: FRONT GATE 1 panel – 71”
...did not pass local zoning due to it being too large - 40' x 80'. The design was done "old school" on a drafting board - then scanned to PDF. I would like to have someone adjust the size of the barn to 32'x72', yet maintain the general overall look/design of the barn. The loft area needs to be redesigned to remove the dance studio and add the following
I have a VBA Macro for scraping data off of a website. The issue is that it comes with duplicates in the excel sheet. I have tried to adjust wait time but this is on and off - works/doesn't work. Need a permanent solution for this so that the VBA just gets the data without duplicates. State your approach to this task and I will hire you.
Hi, I would like to sort some files according to age, size, length and weight, etc. The drop down functions should indicated ranges which i will provide. Also after c...The drop down functions should indicated ranges which i will provide. Also after completion, i should know how to add and delete those ranges. It should be a fairly simple project.
My business name is ' Nu-Decor, painters and decorators' I'd like my logo slightly adjusted as I tried to do it myself but I'm not very good at designing it. I'd like the same layout but use the colours of the 'Dulux' logo attached on the wing part of my logo rather than the colours I have at the moment and wording in dark navy. Also a professional looking bu...
...Database (EXCEL) The first two CSV files I read about the query function in Excel. I then made a little "program", if you want to call it that, tinkered. I also worked a bit with VBA. However, the tool is very limited. The queried files must always have the same file path and must not be named differently. The files must not deviate from the internal structure
I have a VBA Macro for scraping data off of a website. The issue is that it comes with duplicates in the excel sheet. I have tried to adjust wait time but this is on and off - works/doesn't work. Need a permanent solution for this so that the VBA just gets the data without duplicates.
We have a online tool, that was developed unsing the following technologies: Docker • Postgres 9 • PHP 7 • Laravel 5.4 • [login to view URL] 2 • D3.js 3.5 • (Sassy) CSS • Composer / Webpack / Babel The application is an online service. The source code is hosted on gitlab. It is documented and running. Task: - you should take over the software from our develop...
We will provide a set of input files in a folder. Each of the input files need to be read from the folder and based on logic, needs to be converted into another format (excel sheets)
...wish to capture, e.g. not budget/spent, but more attributes for ownership, project health, status, etc. - We want the project owners to input their update into SharePoint and pull that into this workbook, mapping to the data elements in the dashboard - We want to leverage a VBA button to produce a PowerPoint slide of the dashboard to automate our deck
Non-profit business needs spreadsheet to track weekly contributions that will link to Annual total page for each parishioner. Also, spreadsheet needs Master worksheet that allows the addition of names that will automatically update each subsequent worksheets.
This project is to look up 537 Apartments in Borward County Florida. ([login to view URL]) I would like the most recent sale of the property. You will encounter smaller numbers in most cases usually $100. These should be disregarded in place of the larger sale amounts. I want the month/day/year. Attached is a sample
I want a vba code which can be installed in users pc. Which will expire after 1 year and on the expiry they should need to ask me for the licence key again. The programme should not work in another pc.
Write a VBA/Macro Using Excel for analysis a huge number of property information, including all particular, Historical and Current rental status, Rate of Return, Historical and Current Market Value, Profits or Loss and Banking Facilities Information for each of the property.... Steps 1. Design "Master Data Sheets" to contains all information 2. Design
I want to automate 2 reports via VBA Macros as follows (A) AUTOMATE MONTHLY SALES REPORT ANALYSIS A monthly sales report. My Report has the following fields (See attached). My interest is for you to develop a VBA macros script which will automatically on running the script generate the following reports (See attachment) (1) Sales Revenue Analysis
... Currently I have to download the sheet from google drive, look at the changed values and then update my excel sheet (the local excel sheet, on my Laptop). What I want is a VBA code, which I can run on my Local excel, which will fetch values from 3 cells on 3 different tabs on my google drive excel, and then plug those values in my local excel. Its
This project proposes a quality adaptation tunable algorithm that adjusts video streaming quality levels for each user by measuring the average bitrate to make the trade-offs between the average video bitrate and quality switches more seamless. This can be achieved by making the algorithm tunable, allowing individual users to adjust the parameters according
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...
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