Excel 2010 Auto sort
Posted on 2011-03-11
2 worksheets - Labels and Names
Worksheet2 gets data from worksheet1 thusly:
on Worksheet 2 (Being "Names") A3 =Labels!A3, A4 =Labels!A4, etc ...
This list on 'Labels' will continue to be added to so I would like to do this open ended if possible, where entering data on the 'Labels' Worksheet auto-populates on the 'Names' worksheet and also automatically alphabetizes, each time they add an entry on 'Labels'
On the 'Names' worksheet each row will have several columns of information associated with it, so I really need it to sort the rows, based on the 1st column, so columns a - j for example, based on a