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 copy a brand new one over the top in the same cells (A1:D20) my forumula in the E column automatically changes from =SUM(D1) to =SUM(#REF!)
Is there a way I can ensure my formula in the E Column remains the same regardless of what table I insert into A1?
Hope that makes sense?
Thanks
Stephen
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 copy a brand new one over the top in the same cells (A1:D20) my forumula in the E column automatically changes from =SUM(D1) to =SUM(#REF!)
Is there a way I can ensure my formula in the E Column remains the same regardless of what table I insert into A1?
Hope that makes sense?
Thanks
Stephen