Auto Sort

Hi,

Currently any time I add a number in worksheet one it automatically updates on worksheet 2. I would like to be able automatically sort worksheet 2 based on the new numbers as they are added. Is this possible. While I'm pretty proficient in Excel, I have been trying to figure out how to make this work for hours to no avail. I know I can data sort each time, but it's a lot of information and I'd like it to just do it for me

Any help is greatly appreciated!!

Lorin

How was this auto-update done?
May I view the code so that I can make sure it doesn't interfere with it?

In what order is the data sorted? Provide an example.

and finally, if you can attach your workbook or dummy workbook so that we have easier time understanding which column you are trying to sort in what ways and such.

Hi,
I'm attaching a dummy workbook. Feel free to mess around with it...it's updated by the sum function. I got this worksheet from somebody and they asked me to work it so it's mostly automated...any suggestions are greatly appreciated!!

Lorin

Originally Posted by kpark91

How was this auto-update done?
May I view the code so that I can make sure it doesn't interfere with it?

In what order is the data sorted? Provide an example.

and finally, if you can attach your workbook or dummy workbook so that we have easier time understanding which column you are trying to sort in what ways and such.

Wow, thank you so much!! that's exactly what I needed. The only thing is it's a little glitchy because if I enter something on the first page the second page superimposes on it. that's fine, I'm just trying to learn this, so I was wondering why that would happen.
thank you thank you thank you!!