I have some data that I wish to sort in alpha order in one sheet and in
numeric order in another sheet of the same workbook (WinXP, Excel 2003). I
can do the sorts initially with no problem. However, if I add data to the
alpha sort sheet, how can I get the "new" data added (appended) to the
numeric sorted sheet and have it be in numeric order?
I'm only ordering 3 columns of data, but I'm trying to save myself a few
steps. I could set up 1 sheet with original data and then add data only to
that sheet and then copy the sheet twice and then sort the 2 new sheets into
an alpha sort and a numeric sort. But that would mean that every time I
added data to the original sheet I would have to create the 2 extra/new
sheets and do the alpha sort and numeric sort again. There's got to be some
way to add new data to 1 sheet and have the second sheet "update" itself? I
don't care if the alpha sort is my first sheet or my second sheet. I'm just
trying to sort the data in both formats so I can locate it either way.

thanks in advance