21:46 - Erik M. ...so that at least all references are in the same FILE, but not on the same sheet. Changing all that is way too time-consuming, so I just accept it's not possible. Or at least, I don't think it's possible.
21:40 - Erik M. To answer your questions, I tried to change the cell references. I like all my references in one sheet, and I don't want references in another file. So now I just copy the sheet I want + reference sheet to the file...
21:36 - Erik M. No, I have lots of different files with mass balances of different process configurations. Sometimes I need to combine sheets from different files, which at first I had problems with, but now not so much anymore.
21:27 - Erik M. Well, I work with Excel a lot as well for my job, so I've already learned a lot. But seeing as I'm a process engineer, I'm not sure whether you could help me. I mainly set up mass balances in Excel and do lots of calculations.
21:25 - Jaeryd17 What kind of formula changes are you trying to make? Changing the reference to a different file name, or just changing cell references?
21:13 - Zaphod Jooe, [link] You'll probably like this.
01. We Fell From The Bottom 02. The Demon Who Makes Trophies Of Men 03. Fists Of God 04. A Failure 05. Hero Complex 06. Torch Light Search For The Dead 07. A Collapse 08. You Are Alive When They Start To Eat You 09. Bonesaw [iTunes/Amazon bonus]
01. The Starting Line Is A Trip Wire 02. Better World 03. The Well 04. Open Wound 05. Built To Kill 06. The Road Will End 07. Worth The Weight 08. Drawning The Line 09. Happy Hour (Disciples Of Death) 10. Ends Meet