FryGirl
Well-known Member
- Joined
- Nov 11, 2008
- Messages
- 1,360
- Office Version
- 365
- 2016
- Platform
- Windows
I have two sheets, Sheet1 and Sheet2. Need to merge what's additional on Sheet2 into Sheet1.
The column to look for additional data is column B and when a non-match is found, it should be added to Sheet1.
In this example, the new records from Sheet2 are (in column B): Record 4, Recored E, and Record q.
Before (Sheet1)
<tbody>
</tbody>
After (Sheet1)
<tbody>
</tbody>
Source Data (Sheet2)
<tbody>
</tbody>
The column to look for additional data is column B and when a non-match is found, it should be added to Sheet1.
In this example, the new records from Sheet2 are (in column B): Record 4, Recored E, and Record q.
Before (Sheet1)
A | B | C | |
1 | Hdr 1 | Hdr 2 | Hdr 3 |
2 | First | Record 2 | $11,907.00 |
3 | First | Record 3 | $10,175.00 |
4 | First | Record 1 | $2,620.00 |
5 | Second | Record C | $10,544.00 |
6 | Second | Record D | $9,795.00 |
7 | Second | Record A | $8,447.00 |
8 | Second | Record B | $7,885.00 |
9 | Third | Record n | $10,282.00 |
10 | Third | Record m | $9,166.00 |
11 | Third | Record o | $6,197.00 |
12 | Third | Record p | $1,084.00 |
<tbody>
</tbody>
After (Sheet1)
E | F | G | |
1 | Hdr 1 | Hdr 2 | Hdr 3 |
2 | First | Record 2 | $11,907.00 |
3 | First | Record 3 | $10,175.00 |
4 | First | Record 1 | $2,620.00 |
5 | First | Record 4 | |
6 | Second | Record C | $10,544.00 |
7 | Second | Record D | $9,795.00 |
8 | Second | Record A | $8,447.00 |
9 | Second | Record B | $7,885.00 |
10 | Second | Record E | |
11 | Third | Record n | $10,282.00 |
12 | Third | Record m | $9,166.00 |
13 | Third | Record o | $6,197.00 |
14 | Third | Record p | $1,084.00 |
15 | Third | Record q |
<tbody>
</tbody>
Source Data (Sheet2)
A | B | |
1 | Hdr 1 | Hdr 2 |
2 | First | Record 1 |
3 | First | Record 2 |
4 | First | Record 3 |
5 | First | Record 4 |
6 | Second | Record A |
7 | Second | Record B |
8 | Second | Record C |
9 | Second | Record D |
10 | Second | Record E |
11 | Third | Record m |
12 | Third | Record n |
13 | Third | Record o |
14 | Third | Record p |
15 | Third | Record q |
<tbody>
</tbody>