Refresh data imported from the web

[johnrichie]

Hi,


After I imported data from the web, I removed unnecessary rows. But during 'refresh' the unnecessary rows too get displayed. How do I overcome this?


Please help.

 

[Hui]

John


Firstly, Welcome to the Chandoo.org Forums


I don't think you can.


What I do is have all my web links on a Links Page

and pull data off that page as required elsewhere.

 

[johnrichie]

Thank you so much Hui.


I've been trying to update premier league scores & exchange rates. I had referenced the data to another sheet. But once the query gets refreshed it becomes chaotic.


Anyways.. Thank you for the suggestion