I am trying to sort a worksheet so that all rows which are empty in a particular cell ("Sold" In the sample) appear at the bottom of the worksheet while all the rows which contain a value in that cell are then sorted under Artist then Title then Format. Unfortunately, whilst I can sort the rows simply on the Sold cell being empty or containing data, I cannot sort the worksheet so that all rows are in Artist, Label, Format order and all the empty Sold cells appear at the bottom. It seems that I can only sort them either ian alphabetical order or on Sold.
I have attached a sample worksheet. The actual worksheet contains hundred so rows. I should add that I am trying to record a macro (rather than write one) and if you give me some code I won't know where to insert them in the recorded macro.
I have attached a sample worksheet. The actual worksheet contains hundred so rows. I should add that I am trying to record a macro (rather than write one) and if you give me some code I won't know where to insert them in the recorded macro.