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?
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?