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

One option is to add the code to sort the second worksheet on its Activate
method
(if you can live with the sort everytime you change to the worksheet)

Private Sub Worksheet_Activate()

Or you can have a sort macro assigned to a button...

Or to the Workbook Open, Before Save ....

"cjlatta" wrote:

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

Can you explain a bit more about both the sort macro and the Workbook Open,
Before Save options? I've not done the latter and I'm not sure how to go
about setting up the macro. I may be asking too basic a question - I
appreciate any info.
Thanks again.


"Sheeloo" wrote:

One option is to add the code to sort the second worksheet on its Activate
method
(if you can live with the sort everytime you change to the worksheet)

Private Sub Worksheet_Activate()

Or you can have a sort macro assigned to a button...

Or to the Workbook Open, Before Save ....

"cjlatta" wrote:

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