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!!
--
Thanks, Pat

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.

On the File menu, click Save As, and then save the shared workbook on a
network location where other users can gain access to it.


"Pat" wrote:

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!!
--
Thanks, Pat