Need help. I have a spreadsheet where I need to sort my data by column F using a specific text order (red, yellow, green, hold, complete). Whats the best method to accomplish this? Can it be done using Range? or do I have to create an array?
I've specified my dataset range as follows:
FinalRow = Cells(Rows.Count, 1).End(xlUp).Row
Range("A2:H" & FinalRow).Select
I've specified my dataset range as follows:
FinalRow = Cells(Rows.Count, 1).End(xlUp).Row
Range("A2:H" & FinalRow).Select