This is one for a hobby. I have a card collecting spreadsheet that lists all available cards with columns for various stats like name, weapon, class, etc. Final column is either owned, wanted, or just blank. I set up a quicky VBA macro to sort everything by my desired "order of columns" method & it works fine. My problem is that last block of data where status is simply blank. For those cards, and ONLY those cards, I want to simply sort alphabetically by name.
Macro problem is the sort's starting cell is a moving point. Wanted becoming owned is no big deal as those sort correctly with the macro, but occasionally I'll draw one that's currently simple blank status. It's status changes to owned, which means block of data to sort solely by name is overall 1 row smaller. Trying to find proper code to select only those rows where column J = "", and then sort by column A. Given the way the first half of the macro works, those cells will always be continuous block at bottom of spreadsheet. Thankfully it's not a case where they are randomly scattered throughout the body.
Maybe there's a way somehow using the Range function? Automatically create range called Unowned or something like that defined as $A$x : $N$343 where x is first row matching, and then sort the range by column A?
Hope all that gobbledy gook makes sense. Ha! Thanks.
~Vol
Macro problem is the sort's starting cell is a moving point. Wanted becoming owned is no big deal as those sort correctly with the macro, but occasionally I'll draw one that's currently simple blank status. It's status changes to owned, which means block of data to sort solely by name is overall 1 row smaller. Trying to find proper code to select only those rows where column J = "", and then sort by column A. Given the way the first half of the macro works, those cells will always be continuous block at bottom of spreadsheet. Thankfully it's not a case where they are randomly scattered throughout the body.
Maybe there's a way somehow using the Range function? Automatically create range called Unowned or something like that defined as $A$x : $N$343 where x is first row matching, and then sort the range by column A?
Hope all that gobbledy gook makes sense. Ha! Thanks.
~Vol