jennifer865
New Member
- Joined
- Jan 9, 2015
- Messages
- 10
Hello! I am new to VBA and new to this forum! First off:
1. I am using Excel 2010.
2. I have a PC.
Ok, I have 3 sets of data and I need to sort, compare, and align.
Start
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:52px;"><col style="width:197px;"><col style="width:77px;"><col style="width:17px;"><col style="width:52px;"><col style="width:140px;"><col style="width:77px;"><col style="width:17px;"><col style="width:52px;"><col style="width:140px;"><col style="width:77px;"></colgroup><tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
In the above, Set 1 is shown in Columns A-C, Set 2 is in E-G, and Set 3 is in I-K. What I need the macro to do is sort Set 1 by Column A (Asset #) in ascending order. Then, go to Set 2, sort by Column E (Asset #) and match line by line with Set 1, leaving blank lines if an Asset # is not found. Finally, go to Set 3, sort by Column I and match line by line, again leaving blank lines if an Asset # is not found. The final product will look like this:
End
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:52px;"><col style="width:179px;"><col style="width:77px;"><col style="width:17px;"><col style="width:52px;"><col style="width:140px;"><col style="width:77px;"><col style="width:17px;"><col style="width:52px;"><col style="width:140px;"><col style="width:77px;"></colgroup><tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
Your help is much appreciated!
1. I am using Excel 2010.
2. I have a PC.
Ok, I have 3 sets of data and I need to sort, compare, and align.
Start
* | A | B | C | D | E | F | G | H | I | J | K |
1 | ASSET # | ASSET DESCRIPTION | COST | * | ASSET # | ASSET DESCRIPTION | COST | * | ASSET # | ASSET DESCRIPTION | COST |
2 | 0001 | WAREHOUSE | *10,000,000 | * | 0001 | WAREHOUSE | *10,000,000 | * | 0006 | YARD TRACTOR | * * * * *40,000 |
3 | 0014 | SCISSOR LIFT | * * * * *10,000 | * | 0002 | OFFICE BLDG | * *2,000,000 | * | 0007 | FORKLIFT | * * * * *20,000 |
4 | 0004 | 14 ACRE CORP CAMPUS | * *5,000,000 | * | 0003 | GARAGE | * *3,000,000 | * | 0008 | CHEVY VAN | * * * * *20,000 |
5 | 0005 | GMC PICKUP TRUCK | * * * * *20,000 | * | 0004 | 14 ACRE CORP CAMPUS | * *5,000,000 | * | 0012 | COPIER | * * * * * *1,000 |
6 | 0006 | YARD TRACTOR | * * * * *40,000 | * | 0005 | GMC PICKUP TRUCK | * * * * *20,000 | * | 0014 | SCISSOR LIFT | * * * * *10,000 |
7 | 0007 | FORKLIFT | * * * * *20,000 | * | 0006 | YARD TRACTOR | * * * * *40,000 | * | 0001 | WAREHOUSE | *10,000,000 |
8 | 0002 | OFFICE BLDG | * *2,000,000 | * | 0007 | FORKLIFT | * * * * *20,000 | * | 0002 | OFFICE BLDG | * *2,000,000 |
9 | 0003 | GARAGE | * *3,000,000 | * | 0008 | CHEVY VAN | * * * * *20,000 | * | 0003 | GARAGE | * *3,000,000 |
10 | 0008 | CHEVY VAN | * * * * *20,000 | * | 0009 | CONFERENCE DESK | * * * * * *1,000 | * | 0004 | 14 ACRE CORP CAMPUS | * *5,000,000 |
11 | 0009 | CONFERENCE DESK | * * * * * *1,000 | * | 0010 | PHONE SYSTEM | * * * * * *2,000 | * | 0005 | GMC PICKUP TRUCK | * * * * *20,000 |
12 | 0010 | PHONE SYSTEM | * * * * * *2,000 | * | 0012 | COPIER | * * * * * *1,000 | * | 0009 | CONFERENCE DESK | * * * * * *1,000 |
13 | 0011 | REFRIGERATOR | * * * * * *1,000 | * | 0013 | MERCHANDISE PICKER | *10,000,000 | * | 0013 | MERCHANDISE PICKER | *10,000,000 |
14 | 0012 | COPIER | * * * * * *1,000 | * | 0014 | SCISSOR LIFT | * * * * *10,000 | * | 0017 | DELL 300 | * * * * * *1,000 |
15 | 0013 | MERCHANDISE PICKER | *10,000,000 | * | 0015 | LABEL READER | * * * *100,000 | * | * | * | * |
16 | 0015 | LABEL READER | * * * *100,000 | * | 0017 | DELL 300 | * * * * * *1,000 | * | * | * | * |
17 | 0016 | CONVEYOR | * *1,000,000 | * | 0018 | INTEL SPIRON | * * * * * *1,000 | * | * | * | * |
18 | 0020 | PACKER SOFTWARE UPGARDE | * * * * * *3,000 | * | * | * | * | * | * | * | * |
19 | 0018 | INTEL SPIRON | * * * * * *1,000 | * | * | * | * | * | * | * | * |
20 | 0017 | DELL 300 | * * * * * *1,000 | * | * | * | * | * | * | * | * |
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:52px;"><col style="width:197px;"><col style="width:77px;"><col style="width:17px;"><col style="width:52px;"><col style="width:140px;"><col style="width:77px;"><col style="width:17px;"><col style="width:52px;"><col style="width:140px;"><col style="width:77px;"></colgroup><tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
In the above, Set 1 is shown in Columns A-C, Set 2 is in E-G, and Set 3 is in I-K. What I need the macro to do is sort Set 1 by Column A (Asset #) in ascending order. Then, go to Set 2, sort by Column E (Asset #) and match line by line with Set 1, leaving blank lines if an Asset # is not found. Finally, go to Set 3, sort by Column I and match line by line, again leaving blank lines if an Asset # is not found. The final product will look like this:
End
* | A | B | C | D | E | F | G | H | I | J | K |
1 | ASSET # | ASSET DESCRIPTION | COST | * | ASSET # | ASSET DESCRIPTION | COST | * | ASSET # | ASSET DESCRIPTION | COST |
2 | 0001 | WAREHOUSE | *10,000,000 | * | 0001 | WAREHOUSE | *10,000,000 | * | 0001 | WAREHOUSE | *10,000,000 |
3 | 0002 | OFFICE BLDG | * *2,000,000 | * | 0002 | OFFICE BLDG | * *2,000,000 | * | 0002 | OFFICE BLDG | * *2,000,000 |
4 | 0003 | GARAGE | * *3,000,000 | * | 0003 | GARAGE | * *3,000,000 | * | 0003 | GARAGE | * *3,000,000 |
5 | 0004 | 14 ACRE CORP CAMPUS | * *5,000,000 | * | 0004 | 14 ACRE CORP CAMPUS | * *5,000,000 | * | 0004 | 14 ACRE CORP CAMPUS | * *5,000,000 |
6 | 0005 | GMC PICKUP TRUCK | * * * * *20,000 | * | 0005 | GMC PICKUP TRUCK | * * * * *20,000 | * | 0005 | GMC PICKUP TRUCK | * * * * *20,000 |
7 | 0006 | YARD TRACTOR | * * * * *40,000 | * | 0006 | YARD TRACTOR | * * * * *40,000 | * | 0006 | YARD TRACTOR | * * * * *40,000 |
8 | 0007 | FORKLIFT | * * * * *20,000 | * | 0007 | FORKLIFT | * * * * *20,000 | * | 0007 | FORKLIFT | * * * * *20,000 |
9 | 0008 | CHEVY VAN | * * * * *20,000 | * | 0008 | CHEVY VAN | * * * * *20,000 | * | 0008 | CHEVY VAN | * * * * *20,000 |
10 | 0009 | CONFERENCE DESK | * * * * * *1,000 | * | 0009 | CONFERENCE DESK | * * * * * *1,000 | * | 0009 | CONFERENCE DESK | * * * * * *1,000 |
11 | 0010 | PHONE SYSTEM | * * * * * *2,000 | * | 0010 | PHONE SYSTEM | * * * * * *2,000 | * | * | * | * |
12 | 0011 | REFRIGERATOR | * * * * * *1,000 | * | * | * | * | * | * | * | * |
13 | 0012 | COPIER | * * * * * *1,000 | * | 0012 | COPIER | * * * * * *1,000 | * | 0012 | COPIER | * * * * * *1,000 |
14 | 0013 | MERCHANDISE PICKER | *10,000,000 | * | 0013 | MERCHANDISE PICKER | *10,000,000 | * | 0013 | MERCHANDISE PICKER | *10,000,000 |
15 | 0014 | SCISSOR LIFT | * * * * *10,000 | * | 0014 | SCISSOR LIFT | * * * * *10,000 | * | 0014 | SCISSOR LIFT | * * * * *10,000 |
16 | 0015 | LABEL READER | * * * *100,000 | * | 0015 | LABEL READER | * * * *100,000 | * | * | * | * |
17 | 0016 | CONVEYOR | * *1,000,000 | * | * | * | * | * | * | * | * |
18 | 0017 | DELL 300 | * * * * * *1,000 | * | 0017 | DELL 300 | * * * * * *1,000 | * | 0017 | DELL 300 | * * * * * *1,000 |
19 | 0018 | INTEL SPIRON | * * * * * *1,000 | * | 0018 | INTEL SPIRON | * * * * * *1,000 | * | * | * | * |
20 | 0019 | PACKER II SOFTWARE | * * * * * *5,000 | * | * | * | * | * | * | * | * |
21 | 0020 | PACKER SOFTWARE UPGARDE | * * * * * *3,000 | * | * | * | * | * | * | * | * |
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:52px;"><col style="width:179px;"><col style="width:77px;"><col style="width:17px;"><col style="width:52px;"><col style="width:140px;"><col style="width:77px;"><col style="width:17px;"><col style="width:52px;"><col style="width:140px;"><col style="width:77px;"></colgroup><tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
Your help is much appreciated!