Help batch making labels using a list in excel.

Hello, I am new to using macros in Excel but I have experience with programming in VB(Visual Studio). I need some help creating a macro for this project I have.

Basically, I have a list of inventory parts. Each part has a Part Number, Part Name, and Unit Number associated with it. I have a list of over 200 parts in excel that looks like this:

Part Number Part Name Unit Number
1234 Screw 1111
5678 Nut 2222
6234 Bolt 3333
… … …
9999 Washer 5555


I need to be able to take this list and create and inventory tag that looks like this:


2014 Inventory

Part # 1234

Part Name screw

Unit # 1111




I appreciate any assistance you guys can provide.