var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I have to link a table to another table. I created a detailed budget, using three sheets. Sadly, when I add another expense, I have to update it in all three sheets, when it would be awesome to just have a master. I'm using Excel 2007.
In order to achieve this, you will want to use a formula in the individual sheets that references the expense cell(s) in sheet1.
The formula in the individual sheets would be something like this:
Replace sheet1 with the reference sheet name and "A2" with the cell reference that you want to be applied to the other sheets.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors