Referencing Specific Cells on Different Tabs

Copper Contributor

Hey Excel Community,

 

Is there a way to have a specific group of cells, referenced across several tabs, to be able to be updated on any tab and the changes are updated across all tabs? I have a budget spreadsheet in which A5:C14 on all tabs are for numerical inputs (Budget assumptions). Right now, on all tabs, this range is referenced to the first tab. If I want to make a change to the assumptions I have to go to the first tab to make the changes so that it is reflected across all tabs. Is it possible to have these cells linked across all tabs so that I can make the changes on any tab and it is updated across all tabs? 

 

 

0 Replies