Please help create macro!

[amou7]

Hello dear Mr Excel talent! I have an excel sheet where there is a long list of Nato part numbers under twelve TABS (Box 1, Box 2 etc) and under each tab, there is a column L (Nato Serial Number) and I need to put into column K (Description), the name that comes up for that specific number on the Nato website: NATO Codified Commodities | Milspares.

Could someone please create a macro for me? thank you for reading!!

 

[kweaver]

Please use XL2BB when posting your spreadsheet example. Anyone trying to help you doesn't want to retype the data.
It would also help to know what version of Excel you are running -- and reflect that in your profile.

Also, do you already have the descriptions in a sheet. If so, what's the sheet name and how is that sheet structured?

 

[amou7]

Thank you for your reply... In the meantime a few people went and filled it out one by one, so I no longer need the macro. I will delete the thread (if possible) many thanks!