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. False Sense Of Security 02. Surgeon General 03. Will We Ever Learn 04. Free To Maim 05. Missing Link 06. Only You Can Prevent Forest Fires 07. Set The Controls For Oblivion 08. 9 Times Out Of 10 09. Kicked In The Bum By Lee Dorian
01. Waste Isolation 02. Missing Link 03. Guilty Conscience 04. Refuge In A Shell 05. A Tangled Web 06. Hated World 07. Injustice For All 08. All Hope Is Lost 09. In Greed We Trust 10. Dis-Organized Religion 11. My Brothers Keeper 12. To Each His Own 13. Agoraphobic Noise Hair
01. God Is A Sadist 02. I Mitigated Gaul 03. Blatant Defilement Of Itself 04. Afterlife Enslavement 05. The Evils Of Truth 06. To Sleep No More 07. Perils Of Deductive Reasoning 08. Utopian Armageddon 09. Sorry State Of Affairs 10. Suffering Pain, For Some Pleasure 11. Fragile Existence 12. Lust For Chaos 13. Trapped In Delusion 14. Self Hate 15. Rendered Useless 16. Walls That Insecurity Built
01. Bureaucracy Ridiculed 02. Coerced Into Complacency 03. Emotions 04. Falsified Monetary Mitigation 05. Oversaturation 06. The Chains That Grind Us 07. Innefably Inebriated 08. Senselessly Torn Apart By The Corporate Undertow 09. Missing Link 10. Myownworstenemy 11. Endless Struggle With The Invariable Imminence 12. Priorities 13. Red Tape Agenda 14. Desensitized 15. The Epoch Of Catastrophe 16. Mimetic 17. Panoptic 18. Typeface 19. Information Sniper 20. Tokyo 21. Integer
01. Breaking Bad At The Mulberry 02. Waiting To Be Born 03. Gestapolis 04. Inevitable Extinction 05. Global Warning 06. Fraudulent 07. Information Highway To Hell 08. Stress Pandemic 09. Inoperative 10. Deformed By Society 11. The Rail 12. The Alternative Is 13. Blackout 14. Slave 15. Ace Is The King 16. The Last Spark Of Resistance 17. Life Consumed You 18. Ignorance Is Bliss 19. Minefield 20. Fighting Addiction 21. Borealis Storm 22. Poisonous Cure 23. Four Walls 24. The Perpetual Downfall of Man 25. Translucent 26. Almas Por l Infierno 27. Silent Guilt Of The Reaper 28. Contaminant Of The Earth 29. The Blackened Sea 30. Noisearuption
01. Intro 02. Pressure Blast 03. There Is No God 04. Black Trust 05. Indifference 06. Justifiable Homicide/Legal Gangsters 07. Grains Of Sand 08. Educate Hatred 09. Inflated Ego 10. Statue 11. Blood Bag For The Leeches 12. Intermission 13. Surrounded By Control 14. Born Alone, Die Alone 15. Murderous 16. Less Fashion, More Thrashin' 17. Broken Cycle 18. Black Holes 19. Harsh Reality 20. Arm Yourselves 21. 6 Million Miles 22. Fiery Rebirth 23. Outro