Auto sort code to include adjacent columns

Hello guys,

I have an issue with my code that I need to sort my data as it is updated from another sheet. The code I have will only sort the first column and excludes the adjacent column. I need the rows to remain intact as they are sorted since the data is relative. I have looked in previous threads that relate to automatically sorting data but I could not find anything useful for my particular example.

Again, I appreciate any and all help that can be offered to me today

Frantelle

Please Login or Register  to view this content.

Winon

Thanks for your reply and apologies for my delay in responding. Your solution seemed to help although I found the greater portion of my issue to be lying within my name range as I was using a dynamic range. I didn't set the appropriate values in the OFFSET function. Everything is working perfectly now.

Kind regards

Frantelle