Search results for query: data from Website

The addresses on the website where it retrieves the data have changed. Could you please update and repair the Excel file? Thank you. Excel : https://drive.google.com/file/d/1Mq-QSHSMJcExNn8AKEwMP1CWhAoM-Te2/view?usp=sharing

Please help! I am building a personal budget spreadsheet and am looking for the most robust/efficient way to create a multi-level, dependent data validation structure in my "Main Transaction" table. I find myself overwhelmed by the different methods online (Legacy INDIRECT vs. the newer...

Hi! It’s great to hear that you're interested in learning Power BI — it’s definitely a high-demand skill in today’s job market, especially if you’re already comfortable with Excel. To get started, you can check out beginner-friendly YouTube channels like: Guy in a Cube – excellent for...

Hi Experts, I request your kind help in creating a bike chart based on monthly data—Budget vs. Actuals, where one cycle represents the target and the other represents the actuals. Additionally, I would like to learn how to create animation as shown on the website...

In the attached file, I select the orange cell, then go to Data > From Web or Data > Get Data > From Other Sources > From Web. In the URL field (with 'Basic' selected) I enter the following website address, https://finance.yahoo.com/quote/PHP=X/ to pull in the exchange rate between the US...

I have previously used PQ to access information about scheduled sports matched on a webpage that is discontinued and replaced by an API-service. The host of the information is the Norwegian Handball federation and the information is publicly accessible, no tokens, credentials etc... As an...

Hello everyone, I'm working with an online educational platform that caters to UPSC students, and we're trying to enhance how we provide current affairs data. Our goal is to automatically populate an Excel sheet with the title, publishing date, and link of each current affairs post from both...

Hello, the website is up now. After clicking the DISPLAY button (screenshot1), it will bring the user to the list of numbers (screenshot2). It is the number from screenshot2 that I’m interested with.

If some has tight deadline, then isn't is smoother start eg from link New Users - Please Start Here ? and from there New Users Please Read There can find How to get the Best Results at Chandoo.org as well as that other section, which should avoid to do. It'll be a shorter way to get solution. (...

Hi, sorry, I do not have the excel file - i a scraping the data from a website. I appreciate you taking the time to answer! but I am ona tight deadline and will have to get t done today, I was just wondering if anyone had ideas on how to visualise several variables of this kind in a clear way.

Hello Everyone, I was trying to extract shipment tracking data from the shipping line website. Shipment tracking IDs are available in column 1 of my file and I am trying to get data in the next columns. My tracking site is https://www.msc.com/en/track-a-shipment I was trying to get help from...

Hello Chss You can use VBA to import data from a website to Excel, changing the dates on the web page. Here's a basic example to get you started: Sub ImportDataFromWebsite() Dim url As String Dim startDate As Date Dim endDate As Date ' Define website URL url =...

Interested in hiring a Microsoft certified Excel 2019 expert? Hey there! Are you interested in hiring a Microsoft certified Excel 2019 expert? If no, this page is not for you. Who am I? I am a Microsoft Ceritified Excel 2019 Expert. I have excellent understanding of Data, and Database...

Dear Excel experts, Need your guidance on fetching the data from website to excel. Below are the details I will be required website: https://www.cbb.gov.bh/facilities-interest-rates/ Import to excel: Exchange Rates - Historical Search (Table) Date: 1-Jan-2023 to 20-Nov-2023 Require to import...

Hello my Dear,I Want Your Help to Extract Certin Data from this Site https://invoicing.eta.gov.eg/documents to excel Sheet According to the attachments .The data to be extracted from the invoices are the data colored in yellow and blue in this screen and invoice in Pdf form thanks alot with my...

Hi, I created a list of websites in Excel to demonstrate Hyperlinks to a friend, to do this I used Data Validation to create a drop-down list of the website names and in the cell underneath I used VLOOKUP to link to the site that would be selected in the dropdown box (i.e. if they selected a...

Dear Excel Experts, Every day i used to download the indices and stock details file from the nse website. The first file named ind_close_all_21042023 contains all the indices data and the sec_bhavdata_full_21042023 contains all the stocks data. The NSE updates this files on a end today basis...

okay, many thanks

By the way, I would also like to point out the "TERMS AND CONDITIONS OF USE" of the site under "Usage terms" says:[Cut]... You must not conduct any systematic or automated data collection activities such as scraping, data mining and data extraction on the Website. Such data mining or extraction...

Dear Sir, I am not able to import data from following link into excel https://www.valueresearchonline.com/funds/selector/category/101/equity-large-and-midcap/?tab=returns-long-term Error is coming. Kindly suggest Regards Neeraj Kumar Agarwal

I am trying to get the data from https://revenue.cg.nic.in/revcase/Ctz_OfficewisePendingCse.aspx But no data is returned using 'from web' option. I need to access this and many more similar data from this website and analyze them. Are there other ways to do it?

Hi, I am using power query to extract the data from the external website. Also this power query is running in background for every 30 minutes to fetch the data and update in excel workbook. My requirement is i need VBA macro code if the background query refresh completed then i need Message...

Hello all, I have been manually collecting different data sets from different websites over the past 2 years. After 2 years of data collection, I am wondering if there is a way that VBA can be automated to collect the data from online sources and have them arraigned in a specific order. The...

Hello, I have three problems scraping this website https://www.sofascore.com/it/ 1) I have to scroll page to download all I need. I tried to scroll but the data download does not restart from where I had arrived and therefore I risk having double or missing data 2) when I get to the bottom of...

Hello, I am trying to fetch financial data for a list of companies website. In order to automate this, I saved the query as custom function and invoked the same when I have a list of companies. However it is taking more time to refresh. Is there anything that I can do to speed up the...