View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Michael K Michael K is offline
external usenet poster
 
Posts: 2
Default Altering Master list / maintain values in worksheets

I'm using 2000 and this is my first go at lists. I would like to know if
there is a way to arrange my list while keeping the values in my recipies the
same? My list is as follows

Column 1 - ingredient name / Column 2 - cost per weight

I have the cells for each recipe tied back to this one 'master' list so if I
change the arrangement of the list the cells in all of the worksheets change
as well. I would like to keep this list to make quick changes too all
recipies when cost for the ingredients change.

Any ideas?

Many thanks!!!
Michael