Autamatically insert row when data is sorted on another sheet

ExcelDummie675

New member
Joined
Jun 24, 2013
Messages
2
Reaction score
0
Points
0
OK here is my problem... (and I believe VBA is the only way to go)

I'm extracting data from one main sheet to a couple of different sheets. That is already been done by a 'IFERROR' formula.

My next problem is that if I add new client data on the main sheet (at the bottom), and sort it (by name/alphabetically), it adds the new details on the separate sheets but the sorting on those sheets is only done in column B (the name of client). I need it to add l row so that the data I capture on each sheet don't get mixed up...!?!? Only column B is shifted down so data in column C, D, E ... is opposite the wrong name...

If i could explain more in detail: If add "BATMAN" with ID number and sort it on the main sheet... it gets added to the 'Personal Tax' sheet alphabetically. Batman is added after Arista on the ID sheet, but the data (only a 'x') I entered for Bernabe show in the BATMAN row.

I only want to do a "sort data" on the main sheet and all other sheets should be sorted automatically. But the data that's entered on the separate sheet should always stay opposite the correct name... I put a 'x' to mark months/work complete on each client. That 'x' should always stay next to or in the same row as the client name.

Hope this make sense.

PLS HELP!!!
 

Attachments

  • Client List- Main Template - Copy.xlsx
    220.7 KB · Views: 15

ExcelDummie675

New member
Joined
Jun 24, 2013
Messages
2
Reaction score
0
Points
0
SORRY... did not know that! I'm new at the forum thing...

I will make sure that if and when I do get an answer to my problem I will post it here.
 
Top