- Jan 22, 2004
I have a spreadsheet that is used for tracking product yields. Every week we enter information for each batch including weight, cook yield, chill yield, time, etc. Some of the data that is entered will always be the same for each product, such as target yield for cook and chill plus a couple of other items. I'm dealing with about 50 different products, and I would like the "unchanging" data corresponding to the part number entered to be automatically entered into the appropriate cells. As in, when I enter part #99999 the cells for the target yields are automatically filled in with the target yields for part #99999. Is this possible? It gets old having to copy/past this info every week, and I would like to automate the task if I can. Thanks for your thoughts on this...