Greetings all, I have one master excel spreadsheet that I am continually updating along with two other people. Our managers have wanted to pull data from that spreadsheet to view stats so I created a second book that uses macros to copy over the master to do all of the calculations quicker.
Now the managers are wanting to add a new column to where THEY can put information in and I'm wanting to keep the master separate from their copy of it. Has anyone ever dealt with a scenario similar to this and if so, how did you handle it?
I thought about just moving the master over, but then I'd have to track down the person who has it open each time my own team needs to make a change.
Thanks in advance!
Now the managers are wanting to add a new column to where THEY can put information in and I'm wanting to keep the master separate from their copy of it. Has anyone ever dealt with a scenario similar to this and if so, how did you handle it?
I thought about just moving the master over, but then I'd have to track down the person who has it open each time my own team needs to make a change.
Thanks in advance!
