I've got a tricky sorting issue and can't find any reference to this type of issue in previous post's so here goes.
I have information from several forms that update a summary report. This information comes into 3 lines. Meaning the first row is the critical data and the proceeding 2 rows are support info to the first line. Now I’d like to have a vb procedure that will sort the entire workbook yet keep the 2 support rows directely under the newly sorted critical rows.
I thought an array sort could be the way to go but, I’m having trouble getting it to work.
I hope this makes sense. For reference I’ve attached the file.
Thanks in advance for any guidance provided.