View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
please respondhere please respondhere is offline
external usenet poster
 
Posts: 2
Default Need help w/program to randomly sort row data

I've got an Excel worksheet with several columns of data. I want to randomly
shuffle all of the row data and then overwrite column A with sequential
numbers down the column, 1...X, where X is the last row. Any ideas?

Example:


1 B C D
2 G K L
3 D K C

might become

2 G K L
1 B C D
3 D K C

and then with column A renumbered, look like:

1 G K L
2 B C D
3 D K C


I don't know much about Excel at all. How can I develop such a thing.
Furthermore, can this also be done via a command line?

Thanks.