MoRoToRiUm
Well-Known Member
- Joined
- Jun 17, 2008
- Messages
- 1,389
- Reaction score
- 6
I thought I would post since I thought it was a good idea. I wanted a way to keep track of my recipes, as well as any notes/variations/reviews. What better way then a spreadsheet!? Five minutes later, HLOOKUP and some formatting I came up with this.
It's pretty simple- Dump your recipe in any column above C (I like to sort alphabetically then) and then you can simply click the brew you want on the drop down list. I have it set to go down 50 rows, as well as some auto conditioning (Bold for key words, etc). Since I do kits at the moment, I have some samples that were pretty much copied and pasted from Northern Brewer (where I typically get my kits). Hope someone finds this useful!
Oh, and if some one IS interested but needs '03 format let me know. Happy brewing!
It's pretty simple- Dump your recipe in any column above C (I like to sort alphabetically then) and then you can simply click the brew you want on the drop down list. I have it set to go down 50 rows, as well as some auto conditioning (Bold for key words, etc). Since I do kits at the moment, I have some samples that were pretty much copied and pasted from Northern Brewer (where I typically get my kits). Hope someone finds this useful!
Oh, and if some one IS interested but needs '03 format let me know. Happy brewing!