help with excel

porkrind

porkrind

porkrind

Permabanned
Joined
14 Aug 2006
Posts
1,395
i have a large speedsheet that I use to work out some simple formulations i would like to be able to return to the sheet and enter a reference number and recall the previous formulation so i can amend and print out/save again


example formulation
-------------------
recipe_1

red 45.6
blue 12.6
green 5.6


The output is similar to the above, ( i have just simplified it) I would then print and enter new recipes (lots) but i want to be able to come back enter recipe_1 back to the cell that holds the recipe id and be able to recall the data so I could amend then reprint.


so bascially I need to be able to store a array of cells of data and recall that information


I hope that makes sense !! hard to explain



can it be done?
 
I can understand what you're asking for but can't think of anyway of doing it, I'm no excel expert though!

Not sure excel is the application you want to use to do this, sounds like it might be easier just to save the document with the recipe name and open/save as to amend.

I'm guessing you want to keep them all together though and build up a library of recipes?
 
I'm not 100% clear what youre looking for, but if you typed all your recipies into a worksheet, with each data item into various columns (i.e. Red in column A, Green in column B etc), couldnt you use a vlookup function to pull back each of the data items you wanted, based on the value you type in (i.e. type in recipe_1 per your example?)

Sorry if thats not very clear, but if you use the Excel help to 'look up' the vlookup function, you might see what I mean - sorry I cant be more precise at the moment, I'm at work!

If you need more, reply and I'll see if I can illustrate what I mean later on. I hope that helps :)
 
You must log in or register to reply here.
Back
Top Bottom