Sorting rows of data based off a single column for a variable number of entries.

I am trying to sort rows of data based on an identification number. The amount of entries can change. I can use the record macro function and get this code:

Please Login or Register  to view this content.

However, it's messy and depends on the number of entries to be identical each time. Here are some facts that will help:
1) The data always exists starting in B9. There will always be data in this row.
2)The data in column B is already stored in an array, but I'm not sure if that'll help. Likewise, all other columns have their data in separate arrays with the same indices for each row.

I'm having problems with figuring out excel's syntax for sort, but I think if it's possible to clean up the code and select b9 and all values below that (no gaps in file), it should be pretty simple code.

Thanks for any and all guidance.

Thanks tigeravatar,

It was able to sort column B great. That's the kind of simplification I was looking for, but is there a way for it to grab all the data in the row and move that data based on how B was sorted?

Specifically there will be data in column D and/or column G that needs to stay associated with its column B id. The caveat I forgot to mention is columns C, E, and F are blank. I suppose I could change columns D and G to C and D respectively if any changes in code would be significantly more difficult.

Wonderful, works perfectly. Thanks for your help.