Hi,
I have a workbook with a main calculating sheet and several sheets only containing graphs, I would like to be able to have several cells on each graph sheet which will alter some cell values on the main calculating sheet, so that I can alter the values either on the main calculating sheet or on the sheet with the graph and have those changes reflected in both sheets.
Im looking for some advice about a method to do this in Excel 2010.
Thanks
nicksoph
I have a workbook with a main calculating sheet and several sheets only containing graphs, I would like to be able to have several cells on each graph sheet which will alter some cell values on the main calculating sheet, so that I can alter the values either on the main calculating sheet or on the sheet with the graph and have those changes reflected in both sheets.
Im looking for some advice about a method to do this in Excel 2010.
Thanks
nicksoph