Excel Costing Model

I'll try to help:

First, though, what is an element meant to be in relation to recipes and raw ingredients? The layout is similar to recipes.

Also, the way you're laying out information on the recipe/element tabs may not be the best for achieving what you need, but it looks like a good start.

Hi

Yes the sheets will stay constant.

duncandhu _ an element is a seperate recipe e.g. pastry which could go on to be part of another recipe e.g. a lemon tart. These need to be recipes in their own right in order to create the data for element price list tab which should then via a lookup function feed on to the main recipe sheets.

I don't mind changing the layout. I did toy with the idea of putting each recipe / element on it's own tab.

Hi thanks for this. I know what you are saying that manual is clearer but I was hoping to work out some kind of macro programming that if additional elements were added on the elements tab if you ran the macro via a button it would add these to the element price list.

Not that I am not grateful!

Thanks for your help ... that's great!