How do I get 2 workbooks to talk to each other?

S

SamMJLo

Joined
Mar 22, 2006
Messages
6
Reaction score
0
Excel 2003 SP2

I have 1 master workbook with all my info recorded.

I need colleagues to be able to see and input figures into the first 10 columns of worksheet 1 but nothing else.

When changes are made to either workbook I need them to update the other one.

Its not suitable to use passwords/hide columns due to their computer knowledge. I just want them to be able to input values into the first 10 columns and then it updates on the master workbook (and vice-versa).

I need people to have read/write access simulaneously.

Please help as its making my brain ache!

Or at least point me in the direction of HELP!!!

Sam.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Can you get 2 excel workbooks to talk to each other simultaneously? 7
2 Cells on 2 Sheets - How to reference each other 2
Synchronize changes between a workbook and a "master file". 18
Linking workbooks 5
Get relative Path: advanced workbook linking. 1
Code to select rows by a null cell in a set column 3
Excel Populate workbook A from Data in workbook B based off criteria in Workbook C 0
VLOOKUP across multiple workbooks 1

Top