Excel Macro Sort and Data series

[Closed]
Report
Posts
1
Registration date
Friday December 7, 2012
Status
Member
Last seen
December 7, 2012
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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