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

Excel Macro Sort and Data series
How to sort bookmarks in chrome - Guide
Transfer data from one excel worksheet to another automatically - Guide
Spell number in excel without macro - Guide
Audio track download for series - Guide
Best scandinavian crime series on netflix - Guide

1 response

Answer 1 / 1

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

Subscribe To Our Newsletter!