"heatmiserkmp"
wrote in message
news:heatmiserkmp.1xsbmi_1130792743.3432@excelforu m-nospam.com...

Not a power user of Excel. Question:

I have a spreadsheet that another person gave me. It has multple
columns. (user id, user name, menu, security, location,etc) They want
me to add 2 new columns (manager and delete). I have to update this
worksheet with manager names. They want me to create a second
spreadsheet with the same info, but sort it by manager as opposed by
user id. They want the second new worksheet to be updated
automatically when the first spreadsheet is edited.

I tried making a copy of the first worksheet, both worksheets will
update the same info if a select both (as a group), but if I try to
sort the second sheet, of course it will not be the same.

Any hints on how to do this?

Thank You
kim

Do you want a VBA routine to:
1 - copy a Table from Sheet1 to Sheet2
2 - sort Table in Sheet2 by Manager
3 - sort Table in Sheet1 by UserID

???

Ciao
Bruno