Hello
I have about 3000 rows for each sheets . what I want moving range under the same ID from SH1 to SH2
result
I have about 3000 rows for each sheets . what I want moving range under the same ID from SH1 to SH2
OUTPUT.xlsm | |||||
---|---|---|---|---|---|
C | D | E | |||
1 | ID | IMPORT | EXPORT | ||
2 | DFG-001 | 2,000.00 | 123.00 | ||
3 | DFG-002 | 3,456.00 | 34.00 | ||
4 | DFG-003 | 55,444.00 | |||
5 | DFG-001 | 334,456.00 | |||
6 | DFG-005 | 1,222.00 | |||
7 | DFG-006 | ||||
SH1 |
OUTPUT (2) (1).xlsm | |||||
---|---|---|---|---|---|
C | D | E | |||
1 | ID | IMPORT | EXPORT | ||
2 | DFG-001 | 200.00 | |||
3 | DFG-0012 | 3,456.00 | 34.00 | ||
4 | DFG-0013 | 55,444.00 | |||
5 | DFG-0014 | 334,456.00 | |||
6 | DFG-0015 | 1,222.00 | |||
7 | DFG-0016 | ||||
SH2 |
result
OUTPUT.xlsm | |||||
---|---|---|---|---|---|
C | D | E | |||
1 | ID | IMPORT | EXPORT | ||
2 | DFG-002 | 3,456.00 | 34.00 | ||
3 | DFG-003 | 55,444.00 | |||
4 | DFG-005 | 1,222.00 | |||
5 | DFG-006 | ||||
SH1 |
OUTPUT.xlsm | |||||
---|---|---|---|---|---|
C | D | E | |||
1 | ID | IMPORT | EXPORT | ||
2 | DFG-001 | 200.000 | |||
3 | DFG-001 | 2,000.000 | 123.000 | ||
4 | DFG-001 | 334,456.000 | |||
5 | DFG-0012 | 3,456.000 | 34.000 | ||
6 | DFG-0013 | 55,444.000 | |||
7 | DFG-0014 | 334,456.000 | |||
8 | DFG-0015 | 1,222.000 | |||
9 | DFG-0016 | ||||
SH2 |