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