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?

I've also seen a couple other posts similar to my problem, none with any type
of response. Is this action just not possible in Excel? Would it be better
to maintain information such as this in Access instead?

"KKT" wrote:

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?

Tell us what you have in a typical row on the sheet that you want to sort
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"KKT" wrote in message
...
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?