So I've got a Query Table from a web source that I want to paste into Cells A1:D20 say
I've also got a formula in the E Column that I just want to return the value in whatever is in Cell D of the table. eg. In Cell E1 I have the formula =SUM(D1)
Currently when I delete the existing table and...