excel help

PAULRYAN52 · 16 May 2018 at 20:35

hi, can anyone tell me if its possible to auto update cells with prices in them, I've got a spreadsheet with computer components and their price from various sites, is there anyway to automatically update the prices

AHarvey · 17 May 2018 at 16:11

the only time I've done this I was scraping the websites with Python, pulling the prices into a spreadsheet and updating from that.

vvalter · 17 May 2018 at 16:12

Not directly from Excel, you'll have to get the data from the website into a database, excel/word doc, or similar

PAULRYAN52 · 17 May 2018 at 17:07

what can I do

Grrrrr · 17 May 2018 at 22:09

You can try:

Data > Get External Data > From Web

Sometimes it works, sometimes it doesn't. If it doesn't then the alternative is to scrape websites using VBA but it's pretty tricky to do.

PAULRYAN52 · 17 May 2018 at 22:17

I can't get it to work