VB script to autosort a range and output to diff range
Posted by Dave LaFrankie on April 12, 2001 8:34 AM
Running Excel 97
I want to collect data from a range of cells A1:A3, sort it and then output it to a new range B1:B3 automatically. I mean when the data in the first
range changes the second range would automatically be changed and resorted. Can this be done? Is there a VB script I can throw in there to do this?.
1 oranges apples
2 apples oranges
3 pears pears
I would really appreciate your help.