Using Excel 2007. I have a workbook with several worksheets. On my primary
worksheet I have project data information, such as the project number, name,
etc. On all the other worksheets I have linked at least the information from
the project number column, then have added additional information pertaining
to different aspects of the project. Occasionally it would be nice to sort
the data by project number, but I am finding that when I sort my primary
sheet it will only sort that linked cell on the other worksheets. How do I
link/tie the additional information on my other sheets to that project number
so that when I sort the main sheet and it re-organizes the project number on
the other sheets, the other sheets will take that related data in that row
with the project number it's associated with?