I've built a highly parameterized spreadsheet detailing an organization's budget, and I'd like to create a summary document that displays the impact on the bottom line if certain changes are made. (ie changing hourly wage rate, etc) It seems like there has to be a better way to do this than just changing the parameters and making a separate summary table out of hard numbers. Is there a way to program excel to show you what the contents of one cell would be if another cell (or cells) was changed?
Thanks for your help.
mods, if this doesn't belong in general, please move it. I just wasn't sure exactly where to ask.
Bookmarks