Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding rows without the links moving
I've created a set of workbooks, one that is a master inventory list, and the
rest that are recipe costing sheets (this is for a restaurant). What I want to do is link the inventory products to the recipes back to the corresponding production item on the inventory list. The problem that I keep having is that if a add an item to the inventory list (row), the value in the recipe changes because the link follows the cell not the value. Is there a way to prevent this? Can I have these links locked in to specific values, no matter if 2 or 10 rows are added. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding rows without the links moving
Believe the underlying intents here could be served via using either VLOOKUP
or INDEX/MATCH Look through Debra's nice coverage on VLOOKUP or INDEX/MATCH at her: http://www.contextures.com/xlFunctions02.html VLOOKUP http://www.contextures.com/xlFunctions03.html INDEX/MATCH There's also some sample workbooks available for d/l & study -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Harlan" wrote: I've created a set of workbooks, one that is a master inventory list, and the rest that are recipe costing sheets (this is for a restaurant). What I want to do is link the inventory products to the recipes back to the corresponding production item on the inventory list. The problem that I keep having is that if a add an item to the inventory list (row), the value in the recipe changes because the link follows the cell not the value. Is there a way to prevent this? Can I have these links locked in to specific values, no matter if 2 or 10 rows are added. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding rows without the links moving
This seems to be a lot of work for what I want, but I'm willing to give it a
try. Also because of the way the inventory sheet is broken down, I don't know if it will work. Any other suggestions. Thanks "Max" wrote: Believe the underlying intents here could be served via using either VLOOKUP or INDEX/MATCH Look through Debra's nice coverage on VLOOKUP or INDEX/MATCH at her: http://www.contextures.com/xlFunctions02.html VLOOKUP http://www.contextures.com/xlFunctions03.html INDEX/MATCH There's also some sample workbooks available for d/l & study -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Harlan" wrote: I've created a set of workbooks, one that is a master inventory list, and the rest that are recipe costing sheets (this is for a restaurant). What I want to do is link the inventory products to the recipes back to the corresponding production item on the inventory list. The problem that I keep having is that if a add an item to the inventory list (row), the value in the recipe changes because the link follows the cell not the value. Is there a way to prevent this? Can I have these links locked in to specific values, no matter if 2 or 10 rows are added. Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding rows without the links moving
Thanks for feedback. I'm out here. Hang around awhile for possible responses
from others. Good luck ! -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Harlan" wrote in message ... This seems to be a lot of work for what I want, but I'm willing to give it a try. Also because of the way the inventory sheet is broken down, I don't know if it will work. Any other suggestions. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding and Deleting rows - update formulas help needed. | Excel Worksheet Functions | |||
Adding and deleting rows with formulas ****Need Help**** | Excel Discussion (Misc queries) | |||
Adding rows in several worksheets along with formulas | Excel Discussion (Misc queries) | |||
Adding Rows | Excel Discussion (Misc queries) | |||
Insert rows | Excel Worksheet Functions |