Sorting in Excel

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.
 
D

Dennis Tucker

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top