Sort Data automatically using vba

[HaroonSid]

i have a range sheet.name("tota").rangeb4:b53

i want when i put some data in this range then it go auto sort "a to z"

thanx
when i go to that sheet

[Subverter]

Try this:-

Please Login or Register  to view this content.

[TheAnalyticalWolf]

This would be a litte bit shorter

Please Login or Register  to view this content.

[HaroonSid]

Thanx all of u dear

[HaroonSid]

i have a question?

if i sort out automatically data from different sheets at a time

thanx