Excel Macro Sort and Data series

Closed
jggrnt Posts 1 Registration date Friday December 7, 2012 Status Member Last seen December 7, 2012 - Dec 7, 2012 at 11:53 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 7, 2012 at 12:17 PM
I'm looking for a macro that will accomplish 2 things: first I want to sort a range called "data" primary key is "com", secondary key is "cvt", next I want to do a FILL SERIES, ROWS, STEP VALUE 1, in a range named "recno"

Im Running Execl 2007

Thanks

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 7, 2012 at 12:17 PM
For first part you can use macro recorder
1. start macro recorder
2. select the range
3. sort
4. stop recorder
this gives you a macro template
For second part you can do the same
-1