I have and excel spreadsheet with two tabs: Tab 1) an array of data which has a unique ID per person and each person can have 1-20 rows of data. Tab 2) a one page report for which an end-user enters the unique ID and then the report will pre-populate with data from the data tab.
I can't...