Im working with a supply program (Excel 2002) that starts with a 'Master
List' then distributes the information from selected sections to individual
worksheets.  I unserstand how to link information from a particular cell to
different worksheets, but I am dealing with a lot of data and going through
each individual item will take some time.  I am basically looking for a
shortcut.  For example:  on Master List, I have 16 items that all belong to a
box.  The Box has its own worksheet.  This gives me all the info I need for
printing user lists with parts locations, price etc.  I have almos 400 lines
of data to link to another worksheet in the same workbook.  Is there a way to
link the entire liine (all the cells for that particualr part) to an
individual worksheet without having to link each individual cell.