I have two sheets (costing and recipes) that share the same data in column A (Ingredient)(functions as primary key and always initially entered in the costing sheet).
When I add a new Ingredient to the costing sheeting and sort that column it sorts correctly in the costing sheet and all the other data in the costing table sorts with it.
However, only the ingredient column sorts in the recipe sheet and this throws off all the other entered data in the recipe table.
How can I sort a table in the costing sheet that will sort all the data in both spreadsheets to keep aligned with the proper ingredient?
I hope I am explaining this succinctly. Thank you for any help.
When I add a new Ingredient to the costing sheeting and sort that column it sorts correctly in the costing sheet and all the other data in the costing table sorts with it.
However, only the ingredient column sorts in the recipe sheet and this throws off all the other entered data in the recipe table.
How can I sort a table in the costing sheet that will sort all the data in both spreadsheets to keep aligned with the proper ingredient?
I hope I am explaining this succinctly. Thank you for any help.
