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.
21:04 - Erik M. Well, those #DIV/0 can be undone though, but once a cell has #REF! in it, you're screwed unless you didn't save the file, because a simple Crtl + Z doesn't undo it, hahaha. And don't get me started on those circular references...
01. ...As Heaven Declines 02. Rotten And Worthless 03. Hook Handed Demon 04. Damned By Temptation 05. Suffer My Insanity 06. Blessed By The Priest 07. Pray To Lord... 08. Impiety Breed 09. Nailed On Cross (Let Him Fester) 10. Wide Open Cunt
01. The Beginning Of Terror 02. Dripping With Blood 03. Deadly Lessons 04. Wait To Suffer 05. Macabre Fuckfest 06. Infecting The Crypts [Suffocation cover] 07. Ophidicism 08. Entangled In Madness 09. Butchered In Excrement 10. Conquered Suffering
01. A Sacrificed Murder 02. Prepare For The Siege 03. Faireless To The Flesh 04. The Ultimate Damnation 05. Rest Before The Bloodstorm 06. Necronymphomanic 07. Mass Appeal Madness [Napalm Death cover] 08. Divine Illumination 09. The Rapist 10. Blood Spilled
01. Intro 02. Hidden By Disguise 03. Seducer Of Mankind 04. Bloodmarked 05. Until You Kill Yourself 06. Smouldering Human Compost 07. ...And She Loves Anal 08. An Obseding End 09. End Of A Decade 10. Outro