I have a client who goes out and copies stock information to their excel file from the web. This client wants me to make it so all he has to do is open the excel file and it will automatically move the data to his list. What I am trying to do is use a web query to pull the necessary data from the site and be able to move that data to a list on another sheet. (But for simplicity, I am testing it all on one page until i can move it to the real file.)
I can not figure out how to move this data to the list. Please help. Test_List.xlsx I highlighted the cell that needs to be moved to the list.