VBA Updating online data into table

[PJohnson_Construction]

Hey all,

I am charting into unknown territory with pulling data from online website using VBA. I have some VBA experience manipulating data within workbooks, but lack the know how to update from an online source. Here is a synopsis of what I am trying to accomplish. Any help is greatly appreciated.

Will have a worksheet table with say 12 columns.
The first 6 columns will update online from the same website (via command button).
The last 6 columns will be local columns in the worksheet table that will need to adjust accordingly with each online update.
The order of the list will be based off of column 1
The last 6 local columns need to follow column 2
(Column 2 will be the only consistent data from the online source, so my local data needs to anchor to this column in the table. Additionally, column 2 data will have hyperlinks that should be maintained, if possible.)


Thanks All!!

 

[Rijnsent]

Hi PJohnson,
could you please add the code that you already made? Please do so in [ CODE ] [ / CODE ] brackets for readability.
Thanks,
Koen