Modified Gantt Chart for Inventory

I have attached an image of what I'm trying to replicate in excel and a workbook of what I have done in excel so far.

I'm upgrading the inventory list from paper to excel, but I'm having some difficulties accomplishing that in excel to replicate the original inventory layout that has been done for decades. I want it to be as user friendly as possible so users don't have to do any formatting or recoding/debugging.

I'm having a few issues, but first and foremost, I thought graphing the inventory as a gantt chart might be easiest to achieve the same layout as shown in the image. But, I'm not sure how to input all the data as it is a different format from your typical gantt chart.

1. Please let me know how I can input all the information on a graph to replicate the graph layout shown in the image.

I inputted a spin button for users to control inventory through the years as I'm planning to use this from now on. However, I'm not sure how I can use the spin button to control the worksheet depending on the year, or if that's even possible. I want users to be able to use the spin button to see which inventory was used during that year. Right now the spin button year reads 2014, when I hit the arrow to go to 2015, I want it to clear all the 2014 inventory and only display 2015 inventory.

2. Please let me know if it is possible for the spin button to control inventory input for each year.


I know basic coding for VBA, but I typically use other codings provided online and try to manipulate it to what I want. I haven't found a coding that is trying to do what I want.

I feel so overwhelmed cause I know I'm asking a lot with only a basic knowledge of excel, but I'm stuck and have given up after endless Youtube videos and googling.

Please let me know what you think, and I would be truly grateful for the help!

Thanks