Posted By: craxma68
Tracking your inventory? - 05/08/2012 09:46 AM
I use a method of tracking everything I buy and store from ammo to food and water.
I was wondering how many people actually do this?
My main reason behind it being that over time I have acquired so much sh!t that I needed some way of tracking it. I started out with a simple single sheet excel worksheet. It has evolved into a multiple sheet workbook. Now I am considering putting it into MS Access and creating a database.
I like running a constant workbook in MS Excel because I use conditional formatting, things I need to restock on show up in RED! I update this daily for the most part. It is printable so I can take it shopping with me. My wife can print it on her weekly trip to the grocery store, etc.
Thoughts anyone?
I was wondering how many people actually do this?
My main reason behind it being that over time I have acquired so much sh!t that I needed some way of tracking it. I started out with a simple single sheet excel worksheet. It has evolved into a multiple sheet workbook. Now I am considering putting it into MS Access and creating a database.
I like running a constant workbook in MS Excel because I use conditional formatting, things I need to restock on show up in RED! I update this daily for the most part. It is printable so I can take it shopping with me. My wife can print it on her weekly trip to the grocery store, etc.
Thoughts anyone?