Cross-Book updating?

Tropez

New Member
Joined
Apr 19, 2004
Messages
35
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!
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Datsmart

Well-known Member
Joined
Jun 19, 2003
Messages
7,985
What about Sharing the workbook?
Go to Tools | Share WorkBook....
 

Tropez

New Member
Joined
Apr 19, 2004
Messages
35
Ok...well sure...I guess that feature could work as well...

Goes to show some things can be less complicated than they appear.

Thanks!
 

Watch MrExcel Video

Forum statistics

Threads
1,113,990
Messages
5,545,361
Members
410,679
Latest member
rolandbianco
Top