Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
workbook links
I have 2 workbooks, each one contains 19 worksheets which represents each of
our locations, each worksheet contains the employees that work at that location at any given time. I want to link these together so that if an employee changes it is reflected on both worksheets of both workbooks (one workbook is only used in the summer so any changes for the past year need to be reflected in it). I can set the link formula for an individual cell correctly but cannot seem to copy and paste it properly. It would take a looooooooooong time if I had to do this cell by cell for 19 worksheets and hundreds of employees. Any guidelines would be much appreciated. -- Thanks, Pat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems with links to another workbook | Excel Worksheet Functions | |||
workbook links to .xla file on the network | Excel Discussion (Misc queries) | |||
find links to another workbook | Excel Discussion (Misc queries) | |||
Links w/in same workbook not working | Excel Discussion (Misc queries) | |||
#VALUE ! errorr for links to other workbook | Excel Worksheet Functions |