Greetings Wizards.
I'm producing a milestone report were I want to search 2 sheets and bring back any new data in a 3rd.
Essentially, both sheets have the same layout as below. With the detail obviously compiled beneath
<tbody>
</tbody>
So,
Sheet one contains milestones from last week
Sheet two contains milestones from this week
On the third sheet (which is called milestones added) I am intending on the same layout as above and I want to have a lookup which will be searching both of the milestone sheets, and providing data solely on new milestones (new data) that have been added within the week (sheet 2)
I can do a lookup on what's new (what doesn't match) but I can't figure out how to return it correctly.
Your help is very much appreciated.
I'm producing a milestone report were I want to search 2 sheets and bring back any new data in a 3rd.
Essentially, both sheets have the same layout as below. With the detail obviously compiled beneath
C | D | E | F | G |
Milestone ID | Milestone Level | Milestone Name | Finish | % Complete |
<tbody>
</tbody>
So,
Sheet one contains milestones from last week
Sheet two contains milestones from this week
On the third sheet (which is called milestones added) I am intending on the same layout as above and I want to have a lookup which will be searching both of the milestone sheets, and providing data solely on new milestones (new data) that have been added within the week (sheet 2)
I can do a lookup on what's new (what doesn't match) but I can't figure out how to return it correctly.
Your help is very much appreciated.