Excel links

[Pat]

I have two workbooks with similar files in each. Both workbooks have 19
tabs, each tab represents one of our locations and in that tab contains the
employee and their position. I want to link these workbooks so that if a
staff changes from a tab in one workbook it is automatically updated in the
other workbook.

I was able to perform the link in one cell of one tab but could not copy and
paste it to the remainder of the tab. I got the info. contained in the first
cell copied into all cells.

I can perform the link if I do it step by step for each cell which would
prove very cumbersome since we have 19 locations and hundreds of employees.

PLEASE HELP!!

 

[JR]

How about just sharing one workbook?...
Set up a shared workbook
On the Tools menu, click Share Workbook, and then click the Editing tab.

Select the Allow changes by more than one user at the same time check box,
and then click OK.

When prompted, save the workbook.