Hi,
I've spent some time trying to figure this out but I've given up, so, I'm seeking some help please!
I have two workbooks, workbook 1 works as an overiew page and workbook 2 has all the data I want to extract to it.
I have an example below.
Thanks
I've spent some time trying to figure this out but I've given up, so, I'm seeking some help please!
I have two workbooks, workbook 1 works as an overiew page and workbook 2 has all the data I want to extract to it.
I have an example below.
Example.xlsx | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | WORKBOOK 1 | WORKBOOK 2 | ||||||||||
2 | ||||||||||||
3 | REVIEW 1 | REVIEW 2 | ID | Review | Status | Completed by | ||||||
4 | ID | Status | Completed by | Status | Completed by | 1 | Review 1 | Complete | Name 1 | |||
5 | 1 | Complete | Name 1 | 2 | Review 1 | Not started | Name 2 | |||||
6 | 2 | 3 | Review 2 | Needs action | Name 3 | |||||||
7 | 3 | Needs action | Name 3 | |||||||||
8 | ||||||||||||
9 | I want this workbook to pull across the status of reviews if the ID matches, and the review aligns to the header. Example results are populated. | |||||||||||
10 | ||||||||||||
11 | ||||||||||||
12 | ||||||||||||
13 | ||||||||||||
14 | ||||||||||||
15 | ||||||||||||
Sheet1 |
Thanks