Macro for paste UID no from webpage after search for given id present in excel

[Swapnil121mali]

Hello All,

I am having one excel sheet having 20,000 numbers,
Want to find Specific UID number from webpage after do clicking on search tab for particular id present in excel.

Just Like below 4 Steps:

Step 1: copy old id number from excel like 163011

Step 2: paste these number 163011 into Search tab in the website https://www.uid.admin.ch/Search.aspx

Step 3: Click on Search button it will display CHE-116.276.488 as UID

Step 4: Now copy these UID Number from website and paste into the excel

PFA Example :UID.jpgUID1.jpg

I want to do it on over 20,000 entry by manually.

Is there any Macro or Function to find these ?

Help would be really appreciated :-)

data like:
old id----- UID number from Website
163011---> CHE-116.276.488
664148---> CHE-113.495.315
162194--->CHE-105.929.352

Thanks
Swapnil