I have a sheet that has multiple tables and am trying to script a way for the
tables to sort by what is in D. If there is a 1 in D it the data will be
placed in Table 1 and if there is a 2 in D the data will be moved to table 2.
The data I am moving will be in B and C. For my example below data in B and
C will move as follows. Table 1 with 4 in D will move to table 4; Table 2
with 2 in D will stay at table 2; Table 3 with 3 in D will stay in table 3
and Table 4 with 1 in D will move to Table 1.



Table 1
A B C D
1 One 6 2 4
2 Two 3 1
3 Three
4 Four

Table 2
A B C D
1 One 2
2 Two 3 2
3 Three 9 9
4 Four

Table 3
A B C D
1 One 6 3 3
2 Two 2 7
3 Three
4 Four

Table 4
A B C D
1 One 1
2 Two
3 Three 6 2
4 Four 3 1


Thank you

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jeremy" wrote in message
...
I have a sheet that has multiple tables and am trying to script a way for
the
tables to sort by what is in D. If there is a 1 in D it the data will be
placed in Table 1 and if there is a 2 in D the data will be moved to table
2.
The data I am moving will be in B and C. For my example below data in B
and
C will move as follows. Table 1 with 4 in D will move to table 4; Table 2
with 2 in D will stay at table 2; Table 3 with 3 in D will stay in table 3
and Table 4 with 1 in D will move to Table 1.



Table 1
A B C D
1 One 6 2 4
2 Two 3 1
3 Three
4 Four

Table 2
A B C D
1 One 2
2 Two 3 2
3 Three 9 9
4 Four

Table 3
A B C D
1 One 6 3 3
2 Two 2 7
3 Three
4 Four

Table 4
A B C D
1 One 1
2 Two
3 Three 6 2
4 Four 3 1


Thank you