Good morning all... I have an issue that hopefully someone can lead me in the right direction on. I am trying to simplify the managing of data throughout many workbooks.
I would like to have a data worksheet in a source workbook that links to other data worksheets in their respective workbooks so that when I update the original source workbook all the corresponding data worksheets in their respective workbooks will also be updated. Also I would like to be able to add and subtract rows from the original source and that be reflected in the corresponding workbooks as well if possible. And lastly I would like to sort info in the corresponding workbooks without changing the information it references from the original source.
A real life example of what I am trying to achieve is as follows: The source workbook has avocados in cell A1 and the calories in B1 and calories from fat in C1 carbs in D1 etc. etc. along with many other rows of ingredients and their respective nutritional facts. Now I have workbooks for every recipe so I have several separate workbooks that contain a copy of the source ingredient data on sheet 1 as well as recipes on sheet 2 and a nutritional facts label on sheet 3 that references the ingredients from the recipe on sheet 2 and the associated ingredient data on sheet 1 to produce an accurate nutritional fact label on sheet 3. Now with many workbooks containing different recipes there is a distinct advantage for me to have the ability to update one source and have all the linked data on all the workbooks change automatically.
any guidance is much appreciated. Thank you!
I would like to have a data worksheet in a source workbook that links to other data worksheets in their respective workbooks so that when I update the original source workbook all the corresponding data worksheets in their respective workbooks will also be updated. Also I would like to be able to add and subtract rows from the original source and that be reflected in the corresponding workbooks as well if possible. And lastly I would like to sort info in the corresponding workbooks without changing the information it references from the original source.
A real life example of what I am trying to achieve is as follows: The source workbook has avocados in cell A1 and the calories in B1 and calories from fat in C1 carbs in D1 etc. etc. along with many other rows of ingredients and their respective nutritional facts. Now I have workbooks for every recipe so I have several separate workbooks that contain a copy of the source ingredient data on sheet 1 as well as recipes on sheet 2 and a nutritional facts label on sheet 3 that references the ingredients from the recipe on sheet 2 and the associated ingredient data on sheet 1 to produce an accurate nutritional fact label on sheet 3. Now with many workbooks containing different recipes there is a distinct advantage for me to have the ability to update one source and have all the linked data on all the workbooks change automatically.
any guidance is much appreciated. Thank you!
