So we have tab 1 and tab 2 and I am looking to pull various bits of information from both tabs to form the one summary page.
For example, tab 1 will have one line for each person, but tab two will have various lines for the same person, this is driven mainly by column O 'Question' with the answer in column S.
Is there a way to do this, perhaps from copying down the policy numbers on the summary in column A, we can extract the various column info in tab 2 to the summary?
Please see attached example.
Bookmarks