Sort Data Automatically

[dagindi]

Good morning,

I am using the following macro to sort new data when its entered onto a spreadsheet (sample attached). I cannot figure out how to apply the sorting only to row 2 and beyond. The header rows keep getting assorted into the mix.

Please Login or Register  to view this content.

Thanks!

[BadlySpelledBuoy]

It works fine for me, but try changing Header:=xlGuess to Header:=xlYes and see if that works for you.

BSB

[dagindi]

BSB,

Sorry, I should add that the first piece of data needs to be entered in Col A.

If you type ABC in A2, it doesnt push the data in ROW 1 down?

I need ROW 1 headers need to stay in place.

[BadlySpelledBuoy]

I did that and it worked fine on my computer.
But changing xlGuess to xlYes in the code should leave the headers in row 1 where they are, i.e. not include them in the sort.

BSB