Hi I'm quite new to Excel,
I'm costing recipes and have made this ingredient sheet to reference.
When I sort the table A-Z all the data sorts it self correctly on this sheet but when I go to a recipe sheet any formula referencing the D column doesn't update, it stays as the same column as before. Is there a way to make it update across all the sheets without having to do it manually?
Thank you
I'm costing recipes and have made this ingredient sheet to reference.
When I sort the table A-Z all the data sorts it self correctly on this sheet but when I go to a recipe sheet any formula referencing the D column doesn't update, it stays as the same column as before. Is there a way to make it update across all the sheets without having to do it manually?
Thank you