|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to make an Excel Query to update the imported data from a web page by expanding and saving the o
I have an Excel query which read data about price of a commodity form a website table with 30 rows which is updated every day (i.e. every day shows the price of immediate last 30th days). I want to when I update my query, instead of overwriting old data, it expands and save the 30th table row of last day. (i.e. I want my table, after updating, to has 31 rows (the first 30 rows based of new webpage table and the 31th row based on (t-31) price which new webpage table doesn't show any more). Is there a way to do that?
|
Tags |
query, table, webpage |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Issue with Power Query editor/Data model-Excel 2016 | Meg Mika | Excel | 0 | 11-12-2019 01:05 PM |
Activate OptionButton in Powerpoint, if Data is Imported from Excel | Nadal | PowerPoint | 0 | 07-07-2016 06:04 PM |
saving webquery imported data | yoyannick | Excel | 1 | 04-05-2016 04:07 AM |
Update data connection - path, database name, query definition | jaworski_m | Excel | 1 | 08-03-2015 02:37 AM |
How to Query Text in MS-Excel 2010 or Import Data & Query outside of Excel? | mag | Excel | 0 | 10-18-2012 11:15 AM |