Select the cells you want linked and copy them. Move to the sheet where you
want the links to exist and select the appropriate staring cell. Now use
Edit-Paste Special-Paste link


"ALSEGUY" wrote:

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.