Forum Discussion
How To Import A Single Value From A Webpage Into Excell
After you reach to the value after transforming the data, you may right click the value to drill down in order to remove the header in the power query editor itself but the point is, when you load it on to the sheet, since it would be loaded as an excel table, a default header would be added automatically.
Subodh_Tiwari_sktneer Yep thank you figured out you can hide the header in the table properties.
My new problem is this, specifying the value purely from a single selection of the number of rows and columns wont work long term as card stocks change with time and new stock may be added or removed for versions and conditions above the card of interest changing the row its in. What i really need is to specify the set "Rise of Eldrazi" and the condition "NM/M" which will remain constant no matter what and select the value that matches those. Could you suggest a VBA code that could achieve this and/or a place to learn the relevant syntax?