I've started to index my cake magazines, mainly because I couldn't sleep.
Now I've started to realize that the quantity of cake and skills and recipes might make the main index to big (is it to or too, I can never remember) so what I wanted to do was create a sub index where by, for example, with the recipe heading on a separate sheet it will separate out the buttercreams from cake, cupcakes from cookies so that I end up with five new columns.
So eventually I'd end up with three new sheets for the larger fields of information each broken down into their respective headings.
Me being the lazy sod that I am, I want to continue typing into the main index and have the sub indexes self monitor what information they get.
So if I type into the main index, under recipes, Caramel Buttercream, on the Recipe Sub Index under Buttercream, Caramel Buttercream appears with it's relevant issue number.
I hope that makes sense, I'm a little sleep deprived!
Anyway, included is the spreadsheet I'm working on.
You've been a great help in the past.
Bookmarks