keiranwyllie
New Member
- Joined
- May 12, 2017
- Messages
- 47
Hi all,
Can anyone suggest the best to go about this please? I have one workbook that contains 1000's of rows of data. Each row has an ID in column A (This ID may exist on multiple rows). I want to use another workbook that only lists relevant ID, and have the original workbook delete all rows that do not contain any of those IDs (row 1 must remain). See below for example.
Workbook One (before any rows are deleted).
Workbook Two (contains ID of rows I want to keep)
Workbook One (expected data following deletion of rows)
Any help would be greatly appreciated.
Can anyone suggest the best to go about this please? I have one workbook that contains 1000's of rows of data. Each row has an ID in column A (This ID may exist on multiple rows). I want to use another workbook that only lists relevant ID, and have the original workbook delete all rows that do not contain any of those IDs (row 1 must remain). See below for example.
Workbook One (before any rows are deleted).
example.xlsx | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | ID | Name | Title | Dept ID | Cse Name | ||
2 | 100000 | Doe, John | MR | 102983 | Course 1 | ||
3 | 100000 | Doe, John | MR | 102983 | Course 2 | ||
4 | 100000 | Doe, John | MR | 102983 | Course 3 | ||
5 | 100000 | Doe, John | MR | 102983 | Course 4 | ||
6 | 100000 | Doe, John | MR | 102983 | Course 5 | ||
7 | 100000 | Doe, John | MR | 102983 | Course 6 | ||
8 | 110000 | Doe, Jane | MS | 102983 | Course 1 | ||
9 | 110000 | Doe, Jane | MS | 102983 | Course 2 | ||
10 | 110000 | Doe, Jane | MS | 102983 | Course 3 | ||
11 | 110000 | Doe, Jane | MS | 102983 | Course 4 | ||
12 | 110000 | Doe, Jane | MS | 102983 | Course 5 | ||
13 | 110000 | Doe, Jane | MS | 102983 | Course 6 | ||
14 | 120000 | Jane, Mary | MRS | 102983 | Course 3 | ||
15 | 120000 | Jane, Mary | MRS | 102983 | Course 4 | ||
16 | 120000 | Jane, Mary | MRS | 102983 | Course 5 | ||
17 | 120000 | Jane, Mary | MRS | 102983 | Course 6 | ||
18 | 130000 | Lomar, Barry | MR | 102983 | Course 1 | ||
19 | 130000 | Lomar, Barry | MR | 102983 | Course 2 | ||
20 | 130000 | Lomar, Barry | MR | 102983 | Course 3 | ||
21 | 130000 | Lomar, Barry | MR | 102983 | Course 4 | ||
22 | 130000 | Lomar, Barry | MR | 102983 | Course 5 | ||
Sheet1 |
Workbook Two (contains ID of rows I want to keep)
Book1 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | ID | ||||
2 | 110000 | ||||
3 | 130000 | ||||
4 | |||||
Sheet1 |
Workbook One (expected data following deletion of rows)
example.xlsx | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | ID | Name | Title | Dept ID | Cse Name | ||
2 | 110000 | Doe, Jane | MS | 102983 | Course 1 | ||
3 | 110000 | Doe, Jane | MS | 102983 | Course 2 | ||
4 | 110000 | Doe, Jane | MS | 102983 | Course 3 | ||
5 | 110000 | Doe, Jane | MS | 102983 | Course 4 | ||
6 | 110000 | Doe, Jane | MS | 102983 | Course 5 | ||
7 | 110000 | Doe, Jane | MS | 102983 | Course 6 | ||
8 | 130000 | Lomar, Barry | MR | 102983 | Course 1 | ||
9 | 130000 | Lomar, Barry | MR | 102983 | Course 2 | ||
10 | 130000 | Lomar, Barry | MR | 102983 | Course 3 | ||
11 | 130000 | Lomar, Barry | MR | 102983 | Course 4 | ||
12 | 130000 | Lomar, Barry | MR | 102983 | Course 5 | ||
Sheet1 |
Any help would be greatly appreciated.