How can I work with an Excel spreadsheet using Macro or VLookup?
Posted on 2014-12-18
I would like to work with an Excel spreadsheet using either VLookup or a Macro to accomplish the following:
Column A contains item codes
Column B contains the item code description.
Column C contains the Item the Category. (some of these will contain a number from 1 to 100, but many are blank, no data.
I would like to sort this data by Category, so that it lists in order, all lines it finds from 1 onward. Grouping all 1s, 2s, 3s, and so forth, and leaving the blanks at the end after it does not find any more numbers.