Joined
·
30 Posts
Hi everyone,
I would imagine this question has been asked before but I can't find it.
Basically I have a worksheet which contains approx 180 rows and 60 columns, they are predominately numeric values. What I want to do is use sheet1 (s1) for data input and I want to create a sheet2 (s2) to autosort the data contained in s1 everytime I update the data in s1. I only wish to sort by 1 column value, highest at the top to lowest at the bottom.
I am using ms office 2010.
Many thanks in anticipation.
s2m.
I would imagine this question has been asked before but I can't find it.
Basically I have a worksheet which contains approx 180 rows and 60 columns, they are predominately numeric values. What I want to do is use sheet1 (s1) for data input and I want to create a sheet2 (s2) to autosort the data contained in s1 everytime I update the data in s1. I only wish to sort by 1 column value, highest at the top to lowest at the bottom.
I am using ms office 2010.
Many thanks in anticipation.
s2m.