exceldummie675
New Member
- Joined
- May 31, 2013
- Messages
- 5
OK here is my problem...
I need to extract data from one main sheet to a couple of different sheets. That have been done by a excel genius for me. It work like a dream. All data is extracted as it should! See post...
http://www.mrexcel.com/forum/excel-questions/705752-automatically-create-list-table-data-changes-often.html
My next problem is that if I add new client data on the main sheet, 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...
Hope this make sense.
Here is link to my file:
http://sdrv.ms/11FaKCG
I need to extract data from one main sheet to a couple of different sheets. That have been done by a excel genius for me. It work like a dream. All data is extracted as it should! See post...
http://www.mrexcel.com/forum/excel-questions/705752-automatically-create-list-table-data-changes-often.html
My next problem is that if I add new client data on the main sheet, 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...
Hope this make sense.
Here is link to my file:
http://sdrv.ms/11FaKCG