Script to sort tables
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 |
All times are GMT +1. The time now is 11:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com