ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Altering Master list / maintain values in worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/177147-altering-master-list-maintain-values-worksheets.html)

Michael K

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


All times are GMT +1. The time now is 12:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com