Using VBA Code to sort my data automatically

**ssincerely** · 01-10-2013, 12:30 AM

Good Day, let me jus kick it off right away, I am creating a list of criminal records for persons who has one or not and need a VBA Code to auto sort by surnames amount other things, Fig 1 is a sample data

MY PROJ.jpg

1st- I want my Column A to Sort Automatically in ascending order whenever I add a new row of data in row 7, 8 and so on, (table is not sorted now)
2nd-My Range is A1:H5000
3rd- Column F and G must not have any duplicates allowed
4th- In column F when I type 0001 or 2071, I want the letter T to automatically add without me typing it first.
5th- In column G when I type 12001973 or 08912010 I want the symbol - to automatically placed between to numbers as above.
6th- Row 1 is my header row and is frozen

Appreciate the assistance please as I have tried several codes without success(am a newbie to VBA Codes). Respect to all who have shown interest here, thanks.

**jraj1106** · 01-10-2013, 03:42 AM

Hi

Check this out:

Please Login or Register  to view this content.

In the sheet, enter all the details. In col F do not enter "T" just the numbers and in col G do not enter the "-" sign. enter only the nuumbers. After entering the last column ie. "Results" continue pressing the TAB key and move to col I. There you will see all the changes that you wanted.

**jraj1106** · 01-10-2013, 03:49 AM

Sorry I forgot this:
3rd- Column F and G must not have any duplicates allowed

will fix that later..

**ssincerely** · 01-10-2013, 01:25 PM

Thanks man, it works like a charm, thanks again. waiting though on the 3rd and 6th task although I can manipulate it by doing it from the menus but not from the VBA so I'll wait on you, Respect everytime.

**ssincerely** · 01-10-2013, 02:11 PM

I tried changing the table with some formats and add colours, froze the heading and somehow the data didn't sort automatically, however when I run the macro it did. I would prefer auto though but is it that whenever I change the format of the sheet it will affect the code?

Originally Posted by ssincerely

Thanks man, it works like a charm, thanks again. waiting though on the 3rd and 6th task although I can manipulate it by doing it from the menus but not from the VBA so I'll wait on you, Respect everytime.

**ssincerely** · 01-10-2013, 02:12 PM

Thanks man, it works like a charm, thanks again. waiting though on the 3rd and 6th task although I can manipulate it by doing it from the menus but not from the VBA so I'll wait on you, Respect everytime.

I tried changing the table with some formats and add colours, froze the heading and somehow the data didn't sort automatically, however when I run the macro it did. I would prefer auto though but is it that whenever I change the format of the sheet it will affect the code?

Originally Posted by jraj1106

Sorry I forgot this:
3rd- Column F and G must not have any duplicates allowed

will fix that later..