I have a spreadsheet with 98 rows of common problems found while doing
physical surveys of commercial properties. Column 1 contains the item number
(1 - 98). Not all 98 items are found in any one store. How do I create a
report which will bring in the associated information to a blank sheet by
typing in an item number in column 1 (ex. 1, 3, 7, 8, etc.)? TKS