Help With MS Excel 2007

[DavidS]

Hi, can anyone help me? Im trying to get data in a row to follow a specific
cell when doing a sort.
Example.
User Tab(worksheet)>Cell A1 has users name. Example. John Smith
Application Tab(worksheet)>Cell A1 = 'User Tab'!A1 (John Smith)
Columns B-V on Application Tab has users application info.
If I sort Names on USER TAB(worksheet) the corresponding Application TAB will
have the same names but the application info in columns B-V will not stay
with the name. So User Tab(Worksheet) A1 is now Mary Johnson. A1 in
Application Tab(Worksheet) is Mary Johnson but everything else in Columns B-V
on Application Tab belongs to John Smith.
Is there a way to keep the application data info to stick with the name
after the sort. In User Tab(Worksheet)?

Thanks for any help that you can provide.

 

[Jacob Skaria]

Hi David

I am there to help you.

If you have a header for each column, then you can select the header column
and sort which aligns all data to the corresponding record OR you can select
the range and from menu Data-->sort & Filter-->Sort. Please refer the below
link

http://www.homeandlearn.co.uk/excel2007/excel2007s3p1.html

Jacob Skaria
(If this post is helpful please clik Yes)