Ouch. If there were some lovely formulas that could move things around automatically, I could see that working…but I bet people were literally dragging around cells one at a time.
Look, when I paste, it gives me the option to Move Cells to the Right!
I admire your faith in the goodness of people. No, it went in the other direction: editing VBASIC in the developer options and all the horrors that brings. Obviously, that’s too easy to break. So it was locked down. So, of course, people started making copies so they could make it do the things they wanted that it wasn’t supposed to do. It seemed like by the end, each person probably had their own, slightly different copy with degrees of functionality depending on their Excel skills. Not a great environment for making a baseline and a critical path. Do not recommend.
Ouch. If there were some lovely formulas that could move things around automatically, I could see that working…but I bet people were literally dragging around cells one at a time.
I admire your faith in the goodness of people. No, it went in the other direction: editing VBASIC in the developer options and all the horrors that brings. Obviously, that’s too easy to break. So it was locked down. So, of course, people started making copies so they could make it do the things they wanted that it wasn’t supposed to do. It seemed like by the end, each person probably had their own, slightly different copy with degrees of functionality depending on their Excel skills. Not a great environment for making a baseline and a critical path. Do not recommend.