Sorting in Excel

  • Thread starter Thread starter nikos
  • Start date Start date
N

nikos

Hi.
I have in sheet1 in Excel 5 columns with data. The A column has names, the
B age, the C skills, the D salary and the E a code number (as text).
Every few days I add some new names at the end of A column (also the other
data in B,C,D,E) and sometimes I delete a few names.
I would like to find a formula to transfer all those data in sheet2, exactly
the same way, but in ascending order by the name.
(With few words I try to find a way to auto sort and transfer some data.)
Th.
 
I would do this by writing a macro to:
1. Clear space for a sorted copy of your table.
2. Copy the table to the new location.
3. Sort the new table the way you want.
 
Back
Top