Hello, I can't get further with one of my excel tables.
I'm currently working on a Ship Database.
Important information: Every ship has an IMO-Number, this number never change, although they change the name of the ship. There are some websites that provide Ship data. Their URL is based on the ships IMO-Number.
I want to do a Excel table where I can enter the IMO-Number, refresh, and with that number a URL will get completed and I get data like length, year of build, homeport.. etc. for that ship from a website into my table.
Example for a URL: BalticShipping.com"9213997" <- this is the part which needs to base on cell, where I enter the IMO-Number.
So I have created a custom function which completes the URL and gets the data from the website, based on my "IMO-Number"-Table, lets call it register.
The register looks like this:
Now I used my custom function in the Power Query Editor and connected it with the IMO-Number-Register and loaded it into a new spreadsheet.
Now the final table looks like this:
My problem is, that I have two tables now. Everytime I want to enter a new ship in the table, I need to enter the IMO-Number first in my register, and then after a refresh it will appear in my final table.
I want just ONE table where I enter the Number and, based on that, it is going to pull the ship data from web into the SAME table. So the data like length, breadth, vesseltype is connected with my IMO-Number and I have the opportunity to maybe filter it as ONE.
Sorry - my english isn't that good. I hope this was understandable and somebody can help me with that.
Please don't be too hard with me, I'm a bloody beginner.
I have Excel 2019.
Thanks in advance.
I'm currently working on a Ship Database.
Important information: Every ship has an IMO-Number, this number never change, although they change the name of the ship. There are some websites that provide Ship data. Their URL is based on the ships IMO-Number.
I want to do a Excel table where I can enter the IMO-Number, refresh, and with that number a URL will get completed and I get data like length, year of build, homeport.. etc. for that ship from a website into my table.
Example for a URL: BalticShipping.com"9213997" <- this is the part which needs to base on cell, where I enter the IMO-Number.
So I have created a custom function which completes the URL and gets the data from the website, based on my "IMO-Number"-Table, lets call it register.
The register looks like this:
Now I used my custom function in the Power Query Editor and connected it with the IMO-Number-Register and loaded it into a new spreadsheet.
Now the final table looks like this:
My problem is, that I have two tables now. Everytime I want to enter a new ship in the table, I need to enter the IMO-Number first in my register, and then after a refresh it will appear in my final table.
I want just ONE table where I enter the Number and, based on that, it is going to pull the ship data from web into the SAME table. So the data like length, breadth, vesseltype is connected with my IMO-Number and I have the opportunity to maybe filter it as ONE.
Sorry - my english isn't that good. I hope this was understandable and somebody can help me with that.
Please don't be too hard with me, I'm a bloody beginner.
I have Excel 2019.
Thanks in advance.
